Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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.
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
Or you could try with an intersection
Count({
<[Days Old]-$(vLookback)={">=6574"}>
*
<[Days Old]-$(vLookback)={"<=27393"}>
}distinct MRN)