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.
- Convert multi-column tables before being able to use the RoundDown function.
- 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)
- You can round an entire table (single column). The RoundDown function will return a new table with the rounded values.
- 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.
- You can perform arithmetic operations within the function. An example could be
RoundDown((3.14159/4),2)that returns 0.78.
- 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.
- 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.
- 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.
Back to the Power Apps Function Reference