Skip to main content
Hello,
I want to calculate the percentage of Perfect PO,
For that I have to consider certain criterias like -
  1. Out of a list of WFs, I have to include only 1
  2. Payment should be on time
  3. No manual changes after PO ordered
  4. Some more criterias
    I am struggling to calculate this percentage, could anyone help me with this?
    Thank You.

Best Wishes
Khushboo

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


Reply