1 Reply Latest reply: May 14, 2015 11:15 PM by jagan mohan rao appala RSS

    Using maxString in Set Analysis

    Jason Liau

      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