0

Using Oracle APEX 5 classic report: How do I get the average of a column in the subtotal line?

I've read that a "simple" rollup function with an aggregate function for columns should do the trick - can someone please clearly describe how to do this?

Tom
  • 5
  • 3

1 Answers1

1

Are you using a classic report or interactive report?

Interactive Report: Use Actions Menu -> Select Format -> Aggregate -> Function = Average, then select your column. You also need to have aggregate enabled for the column you need to average (located in column attributes)

Classic Report: In the specific Column attributes, I believe you can choose to calculate the average.

theCJCsoccer
  • 601
  • 8
  • 29
  • Hi Chris, I'm using a classic report in APEX 5 - in the attributes I only see a field called Compute Sum (ON/OFF). – Tom Mar 13 '17 at 10:52