PU_COUNT with variable not updated

Hello,

we’re using a formula to determine if only one specific field has been changed or if other fields have been changed as well.

CASE WHEN
PU_COUNT ( “VBAP”, “_CEL_O2C_ACTIVITIES”."_CASE_KEY", “_CEL_O2C_ACTIVITIES”.“CHANGED_FIELD” = <%= Block_types %>) -
PU_COUNT ( “VBAP”, “_CEL_O2C_ACTIVITIES”."_CASE_KEY", “_CEL_O2C_ACTIVITIES”.“ALTERNATIVE_TREE” = ‘Change Management’) = 0
AND
PU_COUNT ( “VBAP”, “_CEL_O2C_ACTIVITIES”."_CASE_KEY", “_CEL_O2C_ACTIVITIES”.“ALTERNATIVE_TREE” = ‘Change Management’) > 0
THEN ‘Block Only’
else
CASE WHEN
PU_COUNT ( “VBAP”, “_CEL_O2C_ACTIVITIES”."_CASE_KEY", “_CEL_O2C_ACTIVITIES”.“CHANGED_FIELD” = <%= Block_types %> ) > 0
THEN
‘Block and other changes’
ELSE ‘Only other changes or no change’ END
END

The formula works fine, but if the variable <%= Block_types %> is changed to a different fields , the formula is not getting updated when used as a filter criteria. It seems that the temporary tables generated by the PU_COUNT are not dropped. Only if the filter is set to initial and activated a 2nd time it works.

Is there a function that does a re-initialize of the PU_COUNT tables or any known workaround?

Thanks in advance.

Holger

Hi Holger,

that’s indeed an odd behaviour - could you please specify how you use the case when as a filter? And which Celonis Verison you’re using?

Best regards,
Viana