5 Replies Latest reply: Aug 1, 2012 6:32 AM by Nicolas MARTIN RSS

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

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

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

       

      for example

       

            if i select apr, may, Jun, Jul then it shows the jul 31st closing balance

       

           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

       

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