Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Convert Formula result to a currency amount

Topic Labels: Formulas
Solved
Jump to Solution
1493 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Christopher_Mes
4 - Data Explorer
4 - Data Explorer

so this is my current Formula - IF({Sold Platform}=“GOAT”,{Unit Sold Price}-({Unit Sold Price}*.095)-5,"")

I am trying to have this result in a $dollar amount. I’ve looked through the community pages but I’m struggling to get the desired result. Can anyone help?

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

Get rid of the final comma and empty quotation marks.

Alternatively, change the final quotation marks to the number 0.

See Solution in Thread

2 Replies 2
ScottWorld
18 - Pluto
18 - Pluto

Get rid of the final comma and empty quotation marks.

Alternatively, change the final quotation marks to the number 0.

Perfect! thanks so much!