Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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