I have the following calculated field inside SharePoint:-

enter image description here

but inside power app canvas i will get a lot of zero (for example 32.000000000000) inside the field, i tried the below formula but it did not remove the zeros:-

enter image description here

any advice how i can show maximum of 2 decimal points as the field is of type currency for USD..

1 Answer 1


Your Parent.Default is possibly considered a Text data type. Can you please try wrapping it in Value() and see if that helps?

Text(Value(Parent.Default),"[$-en-US]$#,###.00", "en-US")

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.