Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I am using the below Expression in order to get data from database start date to till Previous Month end .
=Sum({$<M=,Y=,Month = {"<=$(=MonthEnd(AddMonths(Max(Month),-1)))"}>}Amount)
It is Working fine with Text box Object,but when i use the same expression in Chart object.It is just giving Current month sum.
Dimension is M.
PFA,
please suggest me .Little urgent.
Hi!
I guess you want to show something like this:
You can make it with the "Full accumulation" option in the properties (this image is from google, ignore the red circle):
I hope it helped!
Not sure how your app looks, but you need probably to use an ALL or a TOTAL.
All calculations is done in a chart in regards to the dimension unless you specify it should go outside of that limitation
=Sum(ALL {$<M=,Y=,Month = {"<=$(=MonthEnd(AddMonths(Max(Month),-1)))"}>}Amount)
Cheers,
Martin