Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
Thanks very much in advance
I am trying to sum of amount for date which between
=Sum({<LItem= {'Net Charge'}, xDate = {">=$(=MonthStart(AddMonths(GDate, -12))) <=$(MonthEnd(Addmonths(GDate, -1)))"}>} Amount)
(Some problem in above Set Ana
Any idea please
Thanks
You're missing an = in the second dollar sign expansion:
=Sum({<LItem= {'Net Charge'}, xDate = {">=$(=MonthStart(AddMonths(GDate, -12)))<=$(=MonthEnd(Addmonths(GDate, -1)))"}>} Amount)
Let me clarify please
GDate is DIMENSION here
I need total AMOUNT for last 12 months based on GDate
Meaning
xDate >= AddMonth(gDate, -12) and xDate <= gDate
No variable here
Still not work
If GDate is your dimension, you can't sum values for other GDates, even by putting it in the set analysis. You either need to change your dimension, or look at calculating it in the script.
Hi Nicole
I appreciate your efforts and valuable help
Here
GDate is dimension but I am using xDate and xBalance from another table
GDate is for comparison only
Thanks