web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Rounding off to 2 Deci...
Power Apps
Answered

Rounding off to 2 Decimal Place In PowerApps

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

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

 

Categories:
I have the same question (0)
  • SpongYe Profile Picture
    5,715 Super User 2026 Season 1 on at

    @Anonymous 

     

    You can use this:

     

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

     

     

    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! 🍻

  • Pstork1 Profile Picture
    69,125 Most Valuable Professional on at

    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

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

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

  • Pstork1 Profile Picture
    69,125 Most Valuable Professional on at

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

    Round(Value(varCheckOutPercent), 2)
  • SpongYe Profile Picture
    5,715 Super User 2026 Season 1 on at

    @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

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    It has converted the value from 6.666667 to 0.7

    MOALI_0-1698442148616.png

     

  • SpongYe Profile Picture
    5,715 Super User 2026 Season 1 on at

    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
    Microsoft Employee on at
    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)
  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

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

  • SpongYe Profile Picture
    5,715 Super User 2026 Season 1 on at

    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 .

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 505

#2
WarrenBelz Profile Picture

WarrenBelz 502 Most Valuable Professional

#3
Haque Profile Picture

Haque 324

Last 30 days Overall leaderboard