Hi everyone,
i hope you can help me with a FILTER function.
image716234 8.28 KB
I need a FILTER function with PU_LAST that deletes my cases (in this case it is 98068) when the last activity of Vorgangsart_gend. in column Wert Neu is like /RWEE/DGF.
Can you help?
FILTER PU_LAST("CaseTable", "ActivityTable"."Wert Neu",
"ActivityTable"."Activity" = 'Vorgangsart_gend') != '/RWEE/DGF';
Thanks again. But I have noticed that the formula does not work 100% yet.
Cases without the activity Vorgangsart_gend. 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_gend.)
There are also cases without Vorgangsart_gend..
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_gend' OR PU_LAST("CaseTable", "ActivityTable"."Wert Neu",
"ActivityTable"."Activity" = 'Vorgangsart_gend') != '/RWEE/DGF';Cheers
David
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.