1 Reply Latest reply: Aug 12, 2012 5:02 AM by Babu Vengatesh RSS

    How to find a max date of each months balance value ???

      How to find a max date of each months balance value ???

       

      I used the below expression through this i can get only the max of selected month date balance only

       

      for example

       

            if i select apr, may, Jun, Jul then it shows the jul 31st closing balance of all apr may jun and jul months but i

      expect  

       

          Apr      6257.11

          May    6257.11

          Jun     6257.11

           Jul      6257.11

       

      But expected result is

       

          Apr     5259.15

          May    7256.38

          Jun     5930.41

          Jul      6257.11

       

      the expression i used is

       

      =sum({<Num_Trx_Date={'<=$(=num(vDashboardMaxDate))'},AMISDETAILID={'10022000012879'},YearEnd_Flag={'Without Year End'}>}BS_Amount*Flag)/$(vDiv)