Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
mustafaelryah
Creator
Creator

how to calculate all period till max date selected

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.

10 Replies
mustafaelryah
Creator
Creator
Author

thanks Sunny Talwar, It works