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

Notifications

Announcements

Community site session details

Community site session details

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

Rounding off to 2 Decimal Place In PowerApps

(0) ShareShare
ReportReport
Posted on 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

 

Categories:
I have the same question (0)
  • SpongYe Profile Picture
    5,603 Super User 2025 Season 2 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
    68,697 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
    on at

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

  • Pstork1 Profile Picture
    68,697 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,603 Super User 2025 Season 2 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
    on at

    It has converted the value from 6.666667 to 0.7

    MOALI_0-1698442148616.png

     

  • SpongYe Profile Picture
    5,603 Super User 2025 Season 2 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
    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
    on at

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

  • SpongYe Profile Picture
    5,603 Super User 2025 Season 2 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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 796 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 327 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard