Master Calendar and Set Analysis date ranges

[Anonymous]

Hello,

Is there a way to get a range in the expression?

For instance, I'm trying to find amounts where if a due date is less than the master calendar date but 30 days or less than the master calendar date, show the amount.

I'm thinking it would be something like this but it's all 0's:

Sum({$<DUEDATE={"<=$(=max(Master_Calendar.Date)<=$(=num(DUEDATE)-30))"}>}AMOUNT)

Thank you in advance.

[#2]

hi

try like this

create the variable like

Vmaxcaldate=max(date(Master_Calendar.Date,'DD/MM/YYYY'))

Vprev30days= max(date(DUEDATE,'DD/MM/YYYY'))-30

Use the variable in set

Sum({$<DUEDATE={'>=$(Vmaxcaldate)<=$(Vprev30days)'}>}AMOUNT)