Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Flow Calculation Round up/down

Like (0) ShareShare
ReportReport
Posted on 4 Aug 2022 14:54:34 by 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!

  • jonboylib Profile Picture
    114 on 04 Aug 2022 at 15:20:06
    Re: Flow Calculation Round up/down

    Can I not add the calculation into the formatNumber?

    formatNumber(variables('varRound'),'#0')
    formatNumber(variables(mul(div(float(Actual),float(Budget)),float('100'))),'#0')

     

  • MarconettiMarco Profile Picture
    3,812 Super User 2024 Season 1 on 04 Aug 2022 at 15:05:38
    Re: Flow Calculation Round up/down

    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):

    MarconettiMarco_0-1659625359473.png

    2. Initialize a String variable putting the following expression:

    formatNumber(variables('varRound'),'#0')

    MarconettiMarco_1-1659625442922.png

     

    Here my output:

    MarconettiMarco_2-1659625511110.png

    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

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
stampcoin Profile Picture

stampcoin 125

#2
David_MA Profile Picture

David_MA 118 Super User 2025 Season 1

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 110 Super User 2025 Season 1

Overall leaderboard
Loading started