Filipe S. Martins
Filipe S. Martins

Reputation: 3

How can I format a label or text box to receive currency values using decimal places correctly?

How can I correctly format a label or text box to receive currency values using decimal places?

I have an Excel spreadsheet that acts as a database with financial values for a series of costs. From this database, I use an app developed in powerapps which, when accessed, creates a collection of these values and places them in a gallery. When you click on one of the items in the gallery, the app opens an in-depth description of the selected item. However, values involving financial items do not appear correctly formatted in the corresponding labels.

For example: the cost value X, in the collection, appears as 2326,385 and I would like it to be formatted in currency type, as $ 2,326.38.

For larger amounts, the problem is more pronounced... for example, $36,060.50 appears as 36,060,503.00, using a code similar to the one in example 3.

In the database, the fields are formatted as currency type

None of these options worked correctly, however, I noticed that in values that do not have decimal places after the integer value, the formatting works correctly.

Could you help me with this problem?

I've done the following tests:

VarFormType.COST 

Text(Round(Value(VarFormType.COST);1);"$0.00";Language())

Text(Round(Value(VarFormType.COST);1);"$#,##,0.00";Language())

Value(VarFormType.COST)

Upvotes: 0

Views: 276

Answers (0)

Related Questions