Skip to main content

Notifications

Community site session details

Community site session details

Session Id : uhLuncuV3BRlZX7UeJSUdD
Power Apps - Building Power Apps
Answered

Rounding off to 2 Decimal Place In PowerApps

Like (0) ShareShare
ReportReport
Posted on 27 Oct 2023 21:03:29 by

How can I round Off my float number to 2 decimal places?
For Example, Converting 6.666667 to 6.66 or 6.67

MOALI_0-1698440560333.png

 

  • Verified answer
    SpongYe Profile Picture
    5,580 Super User 2025 Season 1 on 27 Oct 2023 at 21:39:34
    Re: Rounding off to 2 Decimal Place In PowerApps

    Yes, then you need to add the extra text behind it:

     

    Round(Value(varCheckOutPercent), 2) & "%"

    SpongYe_0-1698442820774.png

    If you have any questions or feedback, please let me know. Have a great day! 😊

    -----------------------
    PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

    I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

     

     

  • SpongYe Profile Picture
    5,580 Super User 2025 Season 1 on 27 Oct 2023 at 21:38:35
    Re: Rounding off to 2 Decimal Place In PowerApps

    The varCheckOutPercent looks like it gets divided by 100. 

     

    My results:

    SpongYe_0-1698442640850.png

     

    Your results:

    SpongYe_1-1698442673826.png

     

    Check the variable varCheckOutPercent .

     

  • Community Power Platform Member Profile Picture
    on 27 Oct 2023 at 21:38:14
    Re: Rounding off to 2 Decimal Place In PowerApps

    Is there a way to also show the % with the value?

  • Community Power Platform Member Profile Picture
    on 27 Oct 2023 at 21:34:46
    Re: Rounding off to 2 Decimal Place In PowerApps
    Round(varCheckOutPercent, 2) is giving me 0.27 (Real Value = 26.666667)
    RoundUp(varCheckOutPercent, 2) is giving me 0.27 (Real Value = 26.666667)
    RoundDown(varCheckOutPercent, 2) is giving me 0.26 (Real Value = 26.666667)
  • SpongYe Profile Picture
    5,580 Super User 2025 Season 1 on 27 Oct 2023 at 21:32:53
    Re: Rounding off to 2 Decimal Place In PowerApps

    Hi @Anonymous 

     

    Looks like you want to show the percantage:

    Round(Value(varCheckOutPercent)*100, 2);

    If you have any questions or feedback, please let me know. Have a great day! 😊

    ----------------------
    PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

    I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

  • Community Power Platform Member Profile Picture
    on 27 Oct 2023 at 21:29:53
    Re: Rounding off to 2 Decimal Place In PowerApps

    It has converted the value from 6.666667 to 0.7

    MOALI_0-1698442148616.png

     

  • SpongYe Profile Picture
    5,580 Super User 2025 Season 1 on 27 Oct 2023 at 21:22:00
    Re: Rounding off to 2 Decimal Place In PowerApps

    @Anonymous  you can use one of these:

    Round(varCheckOutPercent, 2); //returns 6.67
    RoundUp(varCheckOutPercent, 2); //returns 6.67
    RoundDown(varCheckOutPercent, 2); //returns 6.66

     

  • Pstork1 Profile Picture
    66,095 Most Valuable Professional on 27 Oct 2023 at 21:14:22
    Re: Rounding off to 2 Decimal Place In PowerApps

    Then you need to put the Text value inside a Value function and that in the Round()

    Round(Value(varCheckOutPercent), 2)
  • Community Power Platform Member Profile Picture
    on 27 Oct 2023 at 21:11:04
    Re: Rounding off to 2 Decimal Place In PowerApps

    So, it is actually not a value. I've called a variable in the Text property called varCheckOutPercent.

  • Pstork1 Profile Picture
    66,095 Most Valuable Professional on 27 Oct 2023 at 21:08:36
    Re: Rounding off to 2 Decimal Place In PowerApps

    Power Apps has functions for RoundUp, RoundDown, and just Round that will let you specify the number of decimal places you want in the floating point number.  This article explains the syntax. Int, Round, RoundDown, RoundUp, and Trunc functions - Power Platform | Microsoft Learn

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

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 Apps - Building Power Apps

#1
MS.Ragavendar Profile Picture

MS.Ragavendar 14

#2
LC-26081402-0 Profile Picture

LC-26081402-0 10

#3
stampcoin Profile Picture

stampcoin 6

Overall leaderboard