Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Decimal Places in Rollups

Topic Labels: Formulas
Solved
Jump to Solution
1227 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Graffikii
4 - Data Explorer
4 - Data Explorer

I'm trying to find the average of a Ratings field for a product using a rollup.

Based on the docs this should work:

 

ROUND(AVERAGE(values), 2)
 
However, I still only get whole numbers back. How can I see the result to two decimal places using a rollup?
1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

 
There is also a format setting in the Formula field.
I think that is where the integer is set.

2023-08-08 091001.png

See Solution in Thread

2 Replies 2
Sho
11 - Venus
11 - Venus

 
There is also a format setting in the Formula field.
I think that is where the integer is set.

2023-08-08 091001.png

Graffikii
4 - Data Explorer
4 - Data Explorer

Great I didn't spot the formatting tab in the Rollup. Thanks for the guidance.

Graffikii_0-1691487962357.png