Answered

Round up when Dividing numbers

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello Teams, I'm using 'Div' function to divide a number by 30 and I want to round up the result. For example, 139/30 = 4.6666....The flow returns the result as 4 , but I want to get the Round Up result, which is 4.666 becomes 5 (whole integer). I tried "int(first(split(string(variables('ee')),'.')))" a solution from another post but it seems not work for me. How should I round up the result? Thanks

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

Jcook 7,781 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hello @Anonymous

could you try this:

if(Mod(float(30),139) > .49,div(float(30),139)+1,div(float(30,139))

Was this reply helpful? Yes No
Verified answer

Ed Gonzales 4,531 Most Valuable Professional on at

Like (4)

Report
Copy link

Link copied!

@Anonymous

Hey there. You could also use the Format Number action, put your dynamic value (or div expression) in the Number field, and then for the Format, select "Add a custom item", and in the pop-up, just enter '#' (without the quotes) and click ok.

The output from that action should be a rounded, whole integer.

Either way, keep us posted. Good luck!

-Ed

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

thanks so much. This solution works for me.

Was this reply helpful? Yes No