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))


      or

       

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


      Has anyone had any luck getting this working before?

      error loading image