Between Date in Set Analysis

[#1]

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

[Nicole-Smith]

You're missing an = in the second dollar sign expansion:

=Sum({<LItem= {'Net Charge'}, xDate = {">=$(=MonthStart(AddMonths(GDate, -12)))<=$(=MonthEnd(Addmonths(GDate, -1)))"}>} Amount)

[#3]

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

[Nicole-Smith]

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.

[#5]

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