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

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

• ###### Re: How to find a max date of each months balance value ???

Hi,

Just Aggregate it by month..So that it will take the Max date for each month and will sove your problem.

Sum(Aggr(

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

,Month

))

Regards,

Desmortes