- Out of a list of WFs, I have to include only 1
- Payment should be on time
- No manual changes after PO ordered
- Some more criterias I am struggling to calculate this percentage, could anyone help me with this? Thank You.
Hello,
I want to calculate the percentage of Perfect PO,
For that I have to consider certain criterias like -
Page 1 / 1
Hi Kushboo,
I recommend using a CASE WHEN statement to include all the conditions that need to be met. Afterwards you would need an aggregator. For example a COUNT(CASE WHEN ... AND.... AND ... THEN CASE_TABLE.CASE_KEY ELSE ... END) and then divide this by the COUNT_TABLE(CASE_TABLE).
Hope this helps
Best
Kevin
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.