Formulas (rounding question)

When I use the formula option, I have not found a way format the number, to 2 or 3 decimal places. How is that done?

Hi @srossiter ,

Welcome.

Multiply the field to 100 then use INT() function, after that divide them with 100.

2 Likes

INT(1.23456789x100)/100=1.23

3 Likes

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.