October 16, 2024

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 Power Apps

Back to the Power Apps Function Reference

Featured Image by Banter Snaps on Unsplash

Manuel Gomes

I have 18 years of experience in automation, project management, and development. In addition to that, I have been writing for this website for over 3 years now, providing readers with valuable insights and information. I hope my expertise allows me to create compelling, informative content that resonates with the audience.

View all posts by Manuel Gomes →

Leave a Reply

Your email address will not be published. Required fields are marked *

Mastodon