Skip to main content
Community site session details

Community site session details

Session Id : dX2yhAb7hqyWLke8bFUbsd
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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Loading complete