Hey Cristian,

Although I am a bit confused, on why you would want to present this KPI on Case Level since it is an aggregation that only makes sense on non-case level, you could just wrap around a is null.

CASE WHEN

ISNULL(your_example) = 1 THEN 0.0 ELSE your_example END

alternatively, you could check if your KPI is greater then 0:

CASE WHEN

your_example > 0.0 THEN your_example ELSE 0.0 END

Best Regards,

Benedict

Hi Bene, Thanks for your response

1- I was trying to find a way to avoid the evaluation of your_example twice, nevertheless this helps .

2- You are saying that this make sense on non-case level? I think its because my problem definition. I stated : " I.e cases that follows ." when the reality It should be number of document items that follows

If this is the case, you are right, if not can you please comment to clarify your statement.

Thanks!

Hi Cristian,

you can avoid having your_example twice by using COALESCE (available in IBC and CPM4.5):

Best

David