IF {PTLTODO_ANNOT_ROUTE.ANNO_SUBCATEGORY} = '11-01P'

AND {PTLTODO_ANNOT_ROUTE.PROJECT} = '1C-130(A)U-2-13 DYNAMIC' THEN 'ZERO DEFECTS' ELSE

'FAIL'

 

This formula provides line chart data (Monthly Count) for ZERO DEFECTS and FAIL action items.

 

From the above data I need to divide FAIL (Monthly Count) by the total of ZERO DEFECTS and FAIL (Monthly Count) to get the FAIL percentage of the total (Monthly Count).

 

I hope I explained what I'm attempting to do clearly.

 

Thanks