Skip to main content
Question

Calculate % Perfect PO

  • November 11, 2019
  • 1 reply
  • 3 views

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