Set Analysis with variable

[lsteere01]

I posted a question earlier today and got a quick answer. This problem is similar but slightly different.

I need to subract the value in a variable (vLookback) from the value in the field [Days Old]. The following does not work:

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

Any ideas?

Thanks.

[sunny_talwar]

Why not do this on the other side of the expression:

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

a-b=c is equivalent to a = b + c, right?

Let me know if this doesn't work.

Best,

Sunny

[lsteere01]

That is true but I'd like to streamline the set analysis if possible, to make it easier to read and possibly run a bit faster.

[sunny_talwar]

Try this in that case: (Havn't tested it, but it should work

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

Sunny

[ramoncova06]

Or you could try with an intersection

Count({

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

*

<[Days Old]-$(vLookback)={"<=27393"}>

}distinct MRN)