Rounding off to 2 Decimal Place In PowerApps

Like (0) Share

Report

Posted on 27 Oct 2023 21:03:29 by Community Power Pla...

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

Categories:

Connecting to Data

General Questions

All responses (11)

Answers (1)

Verified answer

SpongYe 5,580 Super User 2025 Season 1 on 27 Oct 2023 at 21:39:34

Like (0)

Report
Re: Rounding off to 2 Decimal Place In PowerApps

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

Round(Value(varCheckOutPercent), 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! 🍻
SpongYe 5,580 Super User 2025 Season 1 on 27 Oct 2023 at 21:38:35

Like (0)

Report

Re: Rounding off to 2 Decimal Place In PowerApps

The varCheckOutPercent looks like it gets divided by 100.

My results:

Your results:

Check the variable varCheckOutPercent .
Community Power Pla... on 27 Oct 2023 at 21:38:14

Like (0)

Report

Re: Rounding off to 2 Decimal Place In PowerApps

Is there a way to also show the % with the value?
Community Power Pla... on 27 Oct 2023 at 21:34:46

Like (0)

Report
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 5,580 Super User 2025 Season 1 on 27 Oct 2023 at 21:32:53

Like (0)

Report
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 Pla... on 27 Oct 2023 at 21:29:53

Like (0)

Report

Re: Rounding off to 2 Decimal Place In PowerApps

It has converted the value from 6.666667 to 0.7
SpongYe 5,580 Super User 2025 Season 1 on 27 Oct 2023 at 21:22:00

Like (0)

Report
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 66,477 Most Valuable Professional on 27 Oct 2023 at 21:14:22

Like (0)

Report
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 Pla... on 27 Oct 2023 at 21:11:04

Like (0)

Report

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 66,477 Most Valuable Professional on 27 Oct 2023 at 21:08:36

Like (0)

Report

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