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
edited Apr 17, 2020 9:40PM in Reporting & Analytics for B2C Service 1 comment


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


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.


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