1 Reply Latest reply: Jan 29, 2013 7:45 AM by Bobster13 RSS

    Calculation on Aggregate sum row in either Standard or Interactive reports

    Bobster13
      Application Express 4.2.1.00.08

      I've got a report which has 2 main numerical columns
      Submitted
      Rejected
      After these my SQL query does 2 percentage columns
      successful %
      rejected %

      So,
      select
      REGION,
      SUBMITTED,
      REJECTED,
      100-(ROUND(NULLIF(REJECTED,0)/SUBMITTED*100,0))AS "INPUT QUALITY %",
      ROUND(NULLIF(REJECTED,0)/SUBMITTED*100,0)AS "REJECTION %"
      from
      [TABLES] with joins etc...

      PROBLEM:
      In the interactive and Standard report I can then Break by REGION and SUM the SUBMITTED & REJECTED columns

      QUESTION:
      Does anyone know how to calculate the % off the summed columns and display them IN the SUM column?

      Thanks,
      Bob