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?