I have a number column with precision 1 that I Sum and then write to another table to a text column using an action, and ignores the units (that is a known issue with Rollup).
The written value is with the full possible precision.
am I missing something here? bug? any workarounds?
Regardless of the Precision set on a number column, the underlying unrounded value is always stored. If you intend to used the value for other math, you should use a math column with a Round function to give it a true rounded value. Setting Precision and Units is only for display purposes.
Its supposed to show the sum of calories consumed a day,
and I got feedback from my users that were really amazed of the accuracy
Create a math column in whichever table your calorie counts are stored, something like
Round(Calories,0), and then do your rollup on that column.
Round will only work for whole numbers in the math column, I believe. You can’t specify decimal places. If you need to factor in 2 decimal places, for example, you need to multiply by 100, round, then divide by 100.
Whole numbers will work for me in this case.
I will try
Yep, rounding before summing worked.