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.