Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I've been searching everywhere but all solutions for exclude in set analysis also take out null values, which I don't want.
=Count(distinct {$< OverallOutcome-={'Set Up in Error'}>} ReferenceNumber) excludes all nulls
I tried -
=Count(distinct ReferenceNumber) -Count(distinct {$< OverallOutcome={'Set Up in Error'}>} ReferenceNumber)
but that does row by row calculations in effect assigning negative values to errors and removing them twice.
Help!
How about this
=Count(DISTINCT {$<ReferenceNumber = e({<OverallOutcome ={'Set Up in Error'}>})>} ReferenceNumber)
How about this
=Count(DISTINCT {$<ReferenceNumber = e({<OverallOutcome ={'Set Up in Error'}>})>} ReferenceNumber)