Truncate number Action(Power Automate Desktop)
This action truncates a number to an arbitrary number of decimal places.
Get the minority or integer portion, or round to the specified number of digits.
How to use.
Truncate number Action from Variables onto the workspace.
Number to truncate
Specifies the number to be truncated.
Specifies the truncation method.
- Get integer part
- Get decimal part
- Round number
When rounding a number, specify the number of digits.
To round a number, specify the number of digits.
0 is for a whole number, 1 is for one decimal place, and anything less than or equal to two places is rounded to the nearest whole number.
The range is 0 to 28.
Similar to Excel's ROUND function, but integer digits cannot be rounded. (Specify a negative number of digits).
In that case, the following processing is required.
- Divide the number by a multiple of 10 and round off the truncated portion to the decimal point.
- This action truncates the number.
- Multiply the divided number by a multiple of 10 to restore the original digit.
If you want to truncate instead of rounding, the number must be subtracted by -0.5 (depending on the digit).
The value of the result of truncation is stored.