Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try this
='Total: ' & num(sum({$<[Opp Created Year] = {'$(=MaxString([Opp Created Year]))'}>} [Line Total Price - USD]),'$##,###.')
Hope this helps you.
Regards,
Jagan.