Hello community,
at the moment Im working on defining a drop down bottom to filter Production Order having Bad Conditions or without Bad Conditions.
To do so, I use a code like the one below.
Unfortunately, the amount of possible Bad Conditions is so high that after a certain number of
MATCH_PROCESS I get the error:
image.png891111 7.46 KB
But if I separate the formula in 2 pieces, then I get the desired result.
However, Im not able to combine the 2 pieces together and I should have multiple drop down lists as a filter not practical.
Do you have better ideas?
At least do we know if there is a real limited number of conditions that can be added in the CASE WHEN function?
Many thanks,
Francesca
CASE WHEN
** MATCH_PROCESS** (
LOOP[a] AS loop_A,
LOOP[b] AS loop_B,
LOOP[c] AS loop_C
CONNECTED BY DIRECT [loop_A, loop_B], DIRECT [loop_B, loop_C])>0
OR **
** MATCH_PROCESS (
LOOP[a] AS loop_A,
LOOP[b] AS loop_B,
LOOP[d] AS loop_D
CONNECTED BY DIRECT [loop_A, loop_B], DIRECT [loop_B, loop_D])>0
OR **
** MATCH_PROCESS (
LOOP[h] AS loop_H,
LOOP[g] AS loop_G,
LOOP[c] AS loop_C
CONNECTED BY DIRECT [loop_H, loop_G], DIRECT [loop_G, loop_C])>0
**OR **
OR
MATCH_PROCESS (
LOOP[a] AS loop_A,
LOOP[g] AS loop_G,
LOOP[d] AS loop_D
CONNECTED BY DIRECT [loop_A, loop_G], DIRECT [loop_G, loop_D])>0
THEN PO withBad Conditions
ELSE PO wo Bad Conditions
END