Answered

Formatting for Currency

(1) Share

Report

Posted on by Phineas

5,331 Moderator

I have a Gallery where items are being ordered. I would like to tally the
cost of all items in the gallery, in a TextInput outside the Gallery.

How do I write my formula so that a '$' appears in front and any cents
(.00) will appear in the total.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

NickWarner 113 on at

Like (0)

Report
Copy link

Link copied!

almost there, put the text function with the format around the sum function. eg. Text(Sum(Gallery. Allltems, Value(TextInput3_6. Text)),"[$-en-US]$#,#.00")

Was this reply helpful? Yes No
Phineas 5,331 Moderator on at

Like (0)

Report
Copy link

Link copied!

Yes, that worked.

How do I get the Gallery field to look the same ($ and decimals)?

Was this reply helpful? Yes No
NickWarner 113 on at

Like (0)

Report
Copy link

Link copied!

I suspect your unit * qty calculation is failing. When doing arithmetic functions, wrap all the .text values in Value() eg:

Text(Value(TextInput3_3.Text)*Value(TextInput3_5.Text),"[$-en-US]$ #,#.00")

Was this reply helpful? Yes No