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

Jill Cote · 07/07/22

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 · 07/07/22

Is the source data formatted to show decimals?

Paul Newcome · 07/07/22

Is the source data formatted to show decimals?

Jill Cote · 07/08/22

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 · 07/08/22

Happy to help. 👍️

Morris R · 10/31/22

Thank you

This helped me as well.

Odd glitch but worked!

Lisa VanDine · 03/23/23

This technique does not work.

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

Best Answer

Answers

Categories