Forum Discussion
Need help. Pivot table average adding decimal places to whole number
Greetings, I am using a pivot table to compute the average of a list of whole number (ratings 1-5). The pivot table average is returning fractional values so rather than 5, returning 4.63 for examp...
No, you can achieve this.
What I got from your problem.
You are averaging the ratings, but its coming out to be in decimal. You want in a whole number.
If 2.4 then 2 if 4.6 then 5. If its the case . Just follow this
source:https://gyankosh.net/msexcel/how-to-use-pivot-tables-in-excel/#gsc.tab=0e
When you go to the field settings, the picture shown above comes up.
Just go to number format and choose one without the decimals.
Your problem is solved.
*If it was what I understood.
gyankosh Hi, thank you for the response. I follow you, however, the issue is that when the value is graphed it is graphed with the decimal not as a whole number.
