Rolling date range in set analysis expression

[#1]

I am trying to create a set analysis expression that will select transactions that have date from today to three days ago. This is the expressionL

(Sum ({<nDate = {"$((>=num(today())-1))"}>}[Actual Input Qty]))-(Sum ({<nDate = {"$((>=num(today())-1))"}>}[Std Input Qty])) 

This expression returns zero for all instances.  I would appreciate any help you can provide.

[#2]

Hi,

Try to get Day from NDate then using this expression:

sum({<Day= {">=$(=max(Day)-3)<=$(=max(Day))"} >} [Actual Input Qty]-[Std Input Qty])

Hope its can help you.

- Heri

[MayilVahanan]

Hi

  Try this,

   = sum({<nDate = {">= $( = max (nDate) - 3) <= $(= max(nDate) )"}>}[Actual Input Qty] - [Std Input Qty])

hope it helps

[#4 · Accepted solution]

I ended up using the following after creating YearDay using the DayNumberOfYear expression in the load script:

= sum({<"YearDay" = {">=$(=max(YearDay)-4)<=$(=max(YearDay))"}>}[Actual Input Qty] - [Std Input Qty])

Thanks to those who responded.