cancel
Showing results for
Did you mean:
Post Prodigy

## Decimal to Percent

Happy Friday! Power Apps Community,

Is there a way to change or convert decimal numbers and display them as a whole percent? (10%, 25%, 75%, etc...)?

Here is the formula I'm using to show the total score:

``Sum(Gallery8.AllItems,TextInput13)/CountRows(Gallery8.AllItems)*100 & "%"``

In the gallery they have the following controls:

• Items:

``Table({Item:"Yes",Value:100},{Item:"No",Value:0},{Item:"N/A"},{Item:"Other"})``

Text Input

• Default:

``Radio6.Selected.Value&"%"``

(If "Other" is selected, they will put the following percent (25%, 50%, 75%).

As always, thank you in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

Try this:

``Text((Sum(Gallery8.AllItems,TextInput13)/CountRows(Gallery8.AllItems))*100,"#%")``

Hope that helps,

Bryan

_________________________________________________________________________________________
Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.
2 REPLIES 2
Super User

Try this:

``Text((Sum(Gallery8.AllItems,TextInput13)/CountRows(Gallery8.AllItems))*100,"#%")``

Hope that helps,

Bryan

_________________________________________________________________________________________
Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.
Post Prodigy

Thank you 🙏so much @BCLS776 That did the trick.

Announcements

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.