0 Replies Latest reply: Mar 24, 2011 11:06 PM by rain1111 RSS

    Sorting problem with last and before

      Hi all,

      I am calculating the $ Change column with this expression


      =(before( sum(Balance), 1 ) - sum(Balance))

      Now the problem is, I want to sort this in ascending order, basically find out which account has the most declined balance.

      I tried the following expressions for sorting but both do not seem to be working.


      =(before( sum(Balance), 1 ) - sum(Balance))



      =last( (before( sum(Balance), 1 ) - sum(Balance)))

      Has anyone had any luck getting this working before?

      error loading image