Solved

Decimal Places in Rollups

+1

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?

Best answer by Sho

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

+21

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

+1

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

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

Sign up