Need to sum the values of three counts in a KPI chart expression

[fors_gregg]

I'm building a sheet with KPI's counting cases by how long it took to take action, and whether they still are awaiting action.

It's the final one that is giving me difficulty.

It should be easy: Total Count, minus "#<90", minus "#>90" = Remainder

But this does not work:

=Sum({<Count(distinct CMPLN_NBR)-Count({<[ELAPSED_DAYS]={"<=90"}>} distinct CMPLN_NBR)-Count({<[ELAPSED_DAYS]={">90"}>} distinct CMPLN_NBR))>} distinct CMPLN_NBR)

Thanks for your suggestions!

[poklegoguy]

You can try to use the RangeSum function to get the sum of multiple measures:

RangeSum(Count(distinct CMPLN_NBR), Count({<[ELAPSED_DAYS]={"<=90"}>} distinct CMPLN_NBR), Count({<[ELAPSED_DAYS]={">90"}>} distinct CMPLN_NBR))

[pshverma847]

Hello,

Count(DISTINCT {<OCN = {"=Sum(ARRPLUSAUEUR)<=100000"}>} OCN)

My above condition is working absolutely fine, I'm counting the OCNs here where the "ARRPLUSAUEUR"<=100K. Now the problem I'm facing is to give one filter on one of the field in my data and want to restrict the data, but not able to use IF in this condition. Can you please help.

Condition: D_LIFECYCLESTATUSCODE="In Process", This I want to put somewhere in this condition.