How can I round Off my float number to 2 decimal places?
For Example, Converting 6.666667 to 6.66 or 6.67
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! 🍻
The varCheckOutPercent looks like it gets divided by 100.
My results:
Your results:
Check the variable varCheckOutPercent .
Is there a way to also show the % with the value?
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)
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! 🍻
It has converted the value from 6.666667 to 0.7
@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
Then you need to put the Text value inside a Value function and that in the Round()
Round(Value(varCheckOutPercent), 2)
So, it is actually not a value. I've called a variable in the Text property called varCheckOutPercent.
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
MS.Ragavendar
14
LC-26081402-0
10
stampcoin
6