11 Replies Latest reply: Dec 17, 2012 11:55 AM by Kannuri Nagaraju RSS

    quick question regarding first sorted value

      Hi Guys,

       

      I have a text object with the following code:

       

      ='Division with the highest expenses :'  &  firstsortedvalue(Division,-aggr(sum(expenses),Division))

       

      I would like to display the division name that has the highest expenses. There must be something wrong with my expression.

       

      Hope some one can help.

       

      Cheers

       

      Carter!