Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try this maybe:
Count({<[Days Old]={">=$(=6574-$(vLookback))"}>}distinct MRN)
Best,
Sunny
Try this maybe:
Count({<[Days Old]={">=$(=6574-$(vLookback))"}>}distinct MRN)
Best,
Sunny
try like this.....
Count({<[Days Old]={">={6574}-$(vLookback)"}>}distinct MRN)
Seems to work. Thanks!
Doesn't seem to work. Thanks.
Awesome! I am glad it worked.
Best,
Sunny