Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to do a distinct count of Rx# when Refill# = 0. Here's my expression so far...
Count({$<[RX#]=P({1<[Refill#]={0}>}[RX#])>}[RX#])
How do you tweak this to include a distinct count of RX#?
I'm failing at figuring this one out.
Thank you.
Try this:
Count(Distinct {$<[Refil#]={0}>}[RX#])
DISTINCT clause must precede you Set Analysis expression
Thank you Vinivius!