9 Replies Latest reply: Dec 7, 2012 12:05 PM by Vlad Gutkovsky RSS

    how to output a Text field value in a Max based expression ?

      I have an expression like below, but (pulled out the set analysis for readability)

       

      Its a simple Burn rate % expression where I want to show the highest and lowest %. This expression works well.

      My problem is I need to show the Organization along side this one in a neighboring column.

       

      Max(Aggr(Sum(Amount) / Sum(Planned),Organization,Month,ExpLabel ) )

       

      How would I output the corresponding Text Value of the Organization?

       

      Thanks!

      Organizaftion