Announcements
Hi,
I went through tens posts and https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-text but cannot get it working.
How can I achieve Value = 5,354.055 ?
I would also like to round it to 2 decimal places but with syntax like:
Round(Text(DataCardValue4 * DataCardValue5, "[$-en-GB]#,###.##"),2) I'm getting 5354055.
Please help.
Thank you.
Regards
Slawek
😅you got the right value?
what is the issue
if you multiply 1189.7 and 4500 you will get the same Value(5354055)
if you want to get 5,354.055 like this than you need to divide by 1000
Thanks!
I feel embarrassed 🤣🤣🤣
Was copying a paper form and did not pay attention that the price is for 1000 and I should have divided it by 1000
it happens😉
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 355 Most Valuable Professional
11manish 209 Super User 2026 Season 2
MS.Ragavendar 150 Super User 2026 Season 2
