How do I stop my report from generating numbers to the 4th decimal?

Jill Cote

Hi!

I'm using a report that is averaging project duration by year. The "Average" function in the report creation is adding 5 numbers to the right of the decimal. Can this be changed? I know there's a ROUND function that can be used in the sheet, but not in the report?

Thanks!

Chart Using 4 Decimals.JPG

Paul Newcome

Is the source data formatted to show decimals?

Paul Newcome

Is the source data formatted to show decimals?

Jill Cote

Hi Paul,

The source data was set to not show decimals. We set it to three decimals, saved it, set it back to 0 decimals, and it fixed the problem!!

Thanks Paul! Have a great day!

Paul Newcome

Happy to help. 👍️

Morris R

Thank you

This helped me as well.

Odd glitch but worked!

Lisa VanDine

This technique does not work.