Using maxString in Set Analysis

Fri, 15 May 2015 02:08:30 GMT

Hello,

I am trying to get this expression to work:

='Total: ' & num(sum({$<[Opp Created Year] = maxString([Opp Created Year])>} [Line Total Price - USD]),'$##,###.')

but it says error in set modifier element function name. I want to get the sum of line total price - usd of the current max opp created year.

Thanks!

-Jason

Re: Using maxString in Set Analysis

jagan — Fri, 15 May 2015 03:15:11 GMT

Hi,

Try this

='Total: ' & num(sum({$<[Opp Created Year] = {'$(=MaxString([Opp Created Year]))'}>} [Line Total Price - USD]),'$##,###.')

Hope this helps you.

Regards,

Jagan.