Is there a way to truncate/round an average field in an Aggregate Model?
I want to show two decimal places via merge syntax in a rich text area.
I tried to use a formula field, but I had two problems:
- The ROUND function rounds to the nearest integer (no decimals).
- The formula fields don’t seem to respect the metadata settings for decimals (see below)
Here are my formula field settings:
(field should only display two decimal places)
(just a copy of the AVG() function from the aggregate model.
And here’s what I get in runtime: