Help

Decimal Places in Rollups

Topic Labels: Formulas
Solved
Jump to Solution
997 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