2 Replies Latest reply: Sep 22, 2012 3:26 PM by slim Mezghenni RSS

    firstsortedvalue

      I am using this expression below to retrieve the last amount corresponding my selection criteria and it is working fine when i select one client

       

      firstsortedvalue({<Year={'$(vMaxYear)'},Date={'<=$(vMaxDate)'},Month=,Day=,MonthYear=>}Amount,-Date)

       

      My problem i don't knwow how can i have the sum of all clients ?

       

      Can you help me Please

      It is very Urgent.

      Slim.