Hello,

were 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