FILTER out Cases with condition

Hi everyone,

i hope you can help me with a FILTER function.

I need a FILTER function with PU_LAST that deletes my cases (in this case it is 98068) when the last activity of “Vorgangsart_geänd.” in column “Wert Neu” is like /RWEE/DGF.

Can you help?

Hi Steven,

the following PU_LAST will return the “Wert Neu” value of the last ‘Vorgangsart_geänd’ activity for each case. In the FILTER statement, you can then compare against this value to filter cases:

FILTER PU_LAST("CaseTable", "ActivityTable"."Wert Neu", 
"ActivityTable"."Activity" = 'Vorgangsart_geänd') != '/RWEE/DGF';

Best
David

:raised_hands: :handshake:

super. it works. thx

1 Like

Thanks again. But I have noticed that the formula does not work 100% yet.

Cases without the activity “Vorgangsart_geänd.” are not even considered with this formula. These are sorted out.
In principle, I would like to see these cases and check your formula about them.

The problem is

PU_LAST ("/ XFT / INV_Q", “T_CEL_AT_ACCOUNTS_PAYABLE”. “VALUE_NEW”, “T_CEL_AT_ACCOUNTS_PAYABLE”. “TEXT” = “Vorgangsart_geänd.”)

There are also cases without “Vorgangsart_geänd.”.
These should also be counted.

Hope you can help.

Greetings.

Hi,

in order to also filter on the Cases without this particular activity, you can add this condition with an OR. Checking if an activity is contained in a Case can be done in many different ways, but the easiest one is probably using PROCESS NOT EQUALS:

FILTER PROCESS NOT EQUALS 'Vorgangsart_geänd' OR PU_LAST("CaseTable", "ActivityTable"."Wert Neu", 
"ActivityTable"."Activity" = 'Vorgangsart_geänd') != '/RWEE/DGF';

Cheers
David

1 Like