how to calculate all period till max date selected

[mustafaelryah]

Hello all,

I defined max selected date in variable vMaxTransDate  and it works correctly

but I have set analysis in chart i need it to calculate all dates <= vMaxTransDate

Also I have already set analysis on it as shown below

FABS(Sum({$<Account_Budget -= {'NON-Budgeted','-','0'}>} balance))

how can I add  code to set analysis above to calculate all period till vMaxTransDate  where is the date field is Trans_date

Best Regards.

[mustafaelryah]

thanks Sunny Talwar, It works