The RoundDown function rounds a number to a specific number of decimal places, always to the nearest lower number. The round is still down regardless of the last digit. For example, RoundDown(3.14159,4) will return 1.1415 and RoundDown(3.14159,2)will return 3.14.

Limitations

  1. Convert multi-column tables before being able to use the RoundDown function.
  2. You can use also RoundUp for the opposite effect or Round for rounding based on the “Half Round-Up” rule (>=5 rounds up otherwise rounds down)

Recommendations:

  1. You can round an entire table (single column). The RoundDown function will return a new table with the rounded values.
  2. Only use rounding when you want to present a lot of information in a compact view. For calculations ensure you’re using the original values.
  3. You can perform arithmetic operations within the function. An example could be RoundDown((3.14159/4),2) that returns 0.78.
  4. Arithmetic operations can contain variables but, if the value is not a number, the result will be empty and not an error, so be careful when setting the variables.
  5. Use any of the round functions (Round, RoundDown or RoundUp) instead of Text when displaying the information. In the case above you would get a different result of 0.79with Text((3.14159/4),"#,##0.00")but you’d be losing clarity in the formula and not in control in the rounding direction. Use it only if you want a strict display of the result like keeping the right-hand zeros, for example.

Localization

  1. Please note that formulas may have localization-based differences. For example, you should write RoundDown("3.14",2) with “,” separating each of the arguments, but if your localization is Portugal, you should use “;” instead.

Sources:

Round, RoundDown, and RoundUp functions in PowerApps

Back to the PowerApps Function Reference

Featured Image by Banter Snaps on Unsplash

Manuel Gomes

I'm a Project Manager with experience in large projects and companies. I've worked in the past for companies like Bayer, Sybase (now SAP) and I'm currently working for Pestana Hotel Group.

View all posts by Manuel Gomes →

Leave a Reply

%d bloggers like this: