Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
How to show decimal places in 'average' column calculation? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to show decimal places in 'average' column calculation?

Received Response
20
Views
1
Comments
edited Apr 17, 2020 9:40PM in Reporting & Analytics for B2C Service 1 comment

Summary

Using the 'average' calculation is rounding, and I don't want it to.

Content

Hi everyone,

I am trying to use "Edit Calculations" on a report column to get an average. But because the field is of type Integer, the average is getting rounded to the integer. How can I format the average to show two decimal places? I've looked in documentation/forums and can't find how. Here are some more details:

  1. I have a Custom Field on the incident table. It is of type Integer, and allows values 1, 2, 3, 4, or 5.
  2. I want to find the average of this value across all rows when running incident reports. So I add that column to the report. Then I choose "Edit Calculations" and where it lists the usual calculation options (Total, Minimum, Maximum, etc.) I choose "Average".

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!