web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Flow Calculation Round...

Power Automate

Unanswered

Flow Calculation Round up/down

(0) Share

Report

Report

Posted on by jonboylib

114

I have the expression below to calculate a percentage;

mul(div(float(Actual),float(Budget)),float('100'))

This successfully returns a figure of 28.2

How can I round this number up or down? e.g if 2.8.2 round down to 28, or if 28.8 round up to 29.

The number varies, it's not always 28!

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report
Hello @jonboylib ,
please follow these steps:
1. Initialize a Float variable in which put your output (in my case, I've put manually a number):
2. Initialize a String variable putting the following expression:
formatNumber(variables('varRound'),'#0')

Here my output:
So, my number is rounded down, but the same logic is applied for rounding up.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
BR,
Marco

Was this reply helpful? Yes No
jonboylib 114 on at

Like (1)

Report
Can I not add the calculation into the formatNumber?
formatNumber(variables('varRound'),'#0')
formatNumber(variables(mul(div(float(Actual),float(Budget)),float('100'))),'#0')

Was this reply helpful? Yes No

Join the conversation