Increment by 3 decimal places

(0) Share

Report

Posted on by senna

204 Season of Giving Solutions 2025

I have a float variable that I am incrementing for each object in a flow, it starts at 1.001 and then increments by 0.001 using the "Increment Variable" function.

It works fine till it gets to 1.004, I increment it again by 0.001 but the next number returned is 1.00499999999999999 and so on, how can I get it to increment by 3 places exactly? thanks

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Ish S 96 on at

Like (0)

Report
Copy link

Link copied!

Hello senna,

I was able to increment a float variable and I got the expected results.

Would you be able to share a piece of your workflow?

Was this reply helpful? Yes No
senna 204 Season of Giving Solutions 2025 on at

Like (0)

Report
Copy link

Link copied!

thanks @Ish S, I don't think .004 is the issue, its just if it gets incremented many times in a loop, by the 4th or 5th loop of incrementing it by 0.001 it actually increments it by 0.00099999999999999

Was this reply helpful? Yes No
Suggested answer

David_MA 14,078 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Float values in Power Automate use binary floating-point precision (IEEE 754 - Wikipedia) rather than decimal-point precision. You can use an expression to convert your variable to show three decimal places: formatNumber(variables('Value'), '0.000')

Since you don't show your flow, I created a basic example:

Result:

You can use the output of the Compose action for whatever you are doing.

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (0)

Report
Copy link

Link copied!

Use integers to increment/decerement.

Was this reply helpful? Yes No