Application Express 4.2.1.00.08
I've got a report which has 2 main numerical columns
After these my SQL query does 2 percentage columns
100-(ROUND(NULLIF(REJECTED,0)/SUBMITTED*100,0))AS "INPUT QUALITY %",
ROUND(NULLIF(REJECTED,0)/SUBMITTED*100,0)AS "REJECTION %"
[TABLES] with joins etc...
In the interactive and Standard report I can then Break by REGION and SUM the SUBMITTED & REJECTED columns
Does anyone know how to calculate the % off the summed columns and display them IN the SUM column?