Using maxString in Set Analysis

[#1]

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

[jagan]

Hi,

Try this

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

Hope this helps you.

Regards,

Jagan.