In my app result is showing as €13,321,857,600 and €2,921,824,072 but I want result as €133,218,576.00 and €29,218,240.72
Function used in-app is "€"&Text(ThisItem.QuoteValue,"[$-en-US]###,##")
any help here would be really appreciated.
Im from Colombia. I'm havig the same problem in a Form DataCardValue. In the default property of the datacard i use Text(Parent.Default;"[$-en-US]$ #,###"), what i have is € 17,500 and appending it makes it desappear like this:
Please help
I also made negative numbers red, but updating the color property on the advanced tab
If(Value(ThisItem.Field)>0,RGBA(0, 0, 0, 1),Red)
But I am having some issue with second implementation that you have mentioned. I have written for currency format as below
Text(Sum(varCostCapital, varCrntCostCapital, varEditedPrevCap),"[$-en-US]$ ###,##0.00")
This is working fine when US people open the PowerApp form as $ 9500.00. But when Taiwan people are opening this form, currency value is showing as NT$ 9500.00
So I think appending $ infornt of the formula will be good rather than this approach. What is your thought on this?
@Anonymouswrote:In my app result is showing as €13,321,857,600 and €2,921,824,072 but I want result as €133,218,576.00 and €29,218,240.72
Function used in-app is "€"&Text(ThisItem.QuoteValue,"[$-en-US]###,##")
any help here would be really appreciated.
You will need to change the formatting to include the comma, decimal point and trailing zero to include them all.
"€"&Text(ThisItem.QuoteValue,"[$-en-US]###,###.00")
So if your value being converted is equal to:
29218240.72 The conversion looks like €29,218,240.72
and
133218576.00 converts to €133,218,576.00
You can also just include the euro in front of the text formatting without having to add it to the front with &.
Text(ThisItem.QuoteValue,"[$-en-US]€###,###.00"
Let me know how this works out for you!
#1
WarrenBelz
146,700
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,015
Most Valuable Professional
Share
Report
All responses (
Answers (