You’re offline. This is a read only version of the page.
8
Hi All,
I have a text label that displays the total price of a product. When I use the formula Text(Value(ThisItem.Total),"$#,###.00","en-US") and the total is $0, the number displayed is $.00. I would like the number to display $0.00. I tried to add an if statement:
if(
ThisItem.Total = "$.00",
"$0.00",
Text(Value(ThisItem.Total), "$#,###.00", "en-US")
)
however I the number is till displaying as $.00.
If anyone has experience or can assist, please let me know.
Hi @wcd20
The following format string will display 0 as $0.00 (note the 0 before the decimal point)
Share
Report
All responses (
Answers (
Text(Value(ThisItem.Total), "$#,##0.00", "en-US")
