Using a variable in set anaysis.

[lsteere01]

I'm trying to subtract a value stored in a variable (vLookback) from a fixed value (6574) in my set analysis but the syntax I'm using is not working. Any ideas where I'm going wrong?

     Count({<[Days Old]={">=6574-$(vLookback)"}>}distinct MRN)

Thanks.

[sunny_talwar · Accepted solution]

Try this maybe:

Count({<[Days Old]={">=$(=6574-$(vLookback))"}>}distinct MRN)

Best,

Sunny

[#3]

try like this.....

Count({<[Days Old]={">={6574}-$(vLookback)"}>}distinct MRN)

[lsteere01]

Seems to work. Thanks!

[lsteere01]

Doesn't seem to work. Thanks.

[sunny_talwar]

Awesome! I am glad it worked.

Best,

Sunny