Answered

How to display a decimal number as a percentage

(2) Share

Report

Posted on by atray13

147

How can you display a decimal number as a percentage on power apps? For example in this screen shot i have a label where the text value is "0.5", and i would want this to show up as 50%.

Even when the text value is "50%" it still shows up as 0.5 (which wouldn't be of any use anyway but still i have not found a way to display as percentage at all).

I have tried using the text and textformat functions to format it as a percentage to no avail.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

mdevaney 29,989 Moderator on at

Like (5)

Report
@atray13
You can use the TEXT function to format a number in PowerApps

Text(0.5,"0%")

Link to TEXT function documentation:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-text

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
atray13 147 on at

Like (1)

Report

Great that has worked thank you!

Was this reply helpful? Yes No
DCNehs 407 on at

Like (1)

Report

Hi, perhaps someone can help here. I tried using this solution but it's showing there is an error. I'm guessing the math equation is possibly throwing it off? I'm trying to get the "real time" value to show like 11.76%. The calculated column where it's saving to looks ok, but i cant get it to match here.

"Real time value " & (COSellPriceValue - LocalCostValue) / COSellPriceValue,"0%")

Was this reply helpful? Yes No
DCNehs 407 on at

Like (4)

Report

I'm a bit shocked, but it's true, once you start getting a better understanding and can start even looking stuff up, sometimes you can figure it out....of course with the help of older posts 🙂

I DID IT!!

"Real time value "
&
RoundUp((Value(COSellPriceValue.Text)
- Value(LocalCostValue.Text))
/ Value(COSellPriceValue.Text)
* 100,2)

Was this reply helpful? Yes No
PApps1234 12 on at

Like (3)

Report

how about if it has a default parent name on the text formula?
like "Parent.default"
because it has a datasource from microsoft list

Was this reply helpful? Yes No
JPMARAO 6 on at

Like (1)

Report

That's also my problem.

Was this reply helpful? Yes No