Share
ReportHow do i format decimal numbers in PowerApps? I saw how dates can be formatted...but nothing about formatting decimal numbers. Thanks.
You’re offline. This is a read only version of the page.
How do i format decimal numbers in PowerApps? I saw how dates can be formatted...but nothing about formatting decimal numbers. Thanks.
I am trying to multiply two numbers together in a text box and I need it to give me decimal places. But, it is automatically rounding and getting rid of the decimals for some reason.
Here is an example of what I am trying to do:
.32 * 1912.50
I am expecting 611.84
But I am getting 612
I have tried using the text function to format and give me the decimal places. However, when I do that I get 612.00 as the result.
Can someone help me out?
Thank you for the reply, It worked for me when I applied value function of the datacard and used text formatting.
I was implementing this within a Vertical Gallery and the data source was an Excel file on OneDrive.
In this case, I had to format the field like this
Text(Value(ThisItem.Name),"[$-en-US]$#,##0")
@Anonymous wrote:First of all Thanks you verym much for Looking at my issue and soirry for the very late reply.
Following your idea I tried this:
Text(Value(ThisItem.Geplante_x0020_Dauer); "[$-de-DE]#,0")And got this in return:
Geplante Dauer
600000000000000,0
So yes, the "." after the actual number is gone, but the comma shows at the very end after all those 0s.
Right now I guess I will ignore the 0s and shorten the field in lenght so it looks a tad better.
If you think of anything else I'd love to give it a try.
Cheers
Try using Substitute function in order to convert "." to "," and vice versa.
First of all Thanks you verym much for Looking at my issue and soirry for the very late reply.
Following your idea I tried this:
Text(Value(ThisItem.Geplante_x0020_Dauer); "[$-de-DE]#,0")
And got this in return:
Geplante Dauer
600000000000000,0
So yes, the "." after the actual number is gone, but the comma shows at the very end after all those 0s.
Right now I guess I will ignore the 0s and shorten the field in lenght so it looks a tad better.
If you think of anything else I'd love to give it a try.
Cheers
You need to adjust the format in function of what you're using as decimal separator in German locale.
If it is the comma, try "[$-de-DE]#,0" with a comma instead of a period.
Hi,
I am currently also trying to get rid of my decimals, but seem to be stuck.
I have a calculated value in minutes as a single line of text, based on two date/time entries.
=GANZZAHL(([Geplanter Einsatztermin Ende]-[Geplanter Einsatztermin])*1440)
The value in this example is 60 minutes, see first attachment, which looks as expected in the Sharepoint item.
Now when I pull this single line of text into my Powerapp, I get the "hostile" decimals (second screenshot) 🙂
I tried this:
Text(ThisItem.Geplante_x0020_Dauer*1; "[$-de-DE]#.0")
and
Text(Value(ThisItem.Geplante_x0020_Dauer); "[$-de-DE]#.0")
But end up only getting more dots in between all the 0s, but no matter what I try the 0 remain.
With this code:
Text(Value(ThisItem.Geplante_x0020_Dauer); "[$-de-DE]#")
I get rid of the dot after the "60", but also the 0s remain 😞
Any ideas?
Thanks a lot in advance!
Interesting, thank you! So you can multiply by 1 any string that can be converted to a number? Neat.
#1
WarrenBelz
146,700
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,015
Most Valuable Professional
All responses (
Answers (
