Help

String formatting

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

IF({amount of discount}=0," ",IF({amount of discount}<0,{amount of discount}))

I got this to do what I want - only show a value on a sales receipt if the value is <0

The problem is that the answer is considered a string answer and I cannot format it to display as currency. All fields leading into this formula are numbers (formatted currency) I want the results to be displayed as currency.

Suggestions?

1 Solution

Accepted Solutions
Kamille_Parks
16 - Uranus
16 - Uranus

The outcome is considered a string because a possible value based on your formula is a space character, instead of BLANK(). You could simplify your formula to just be your nested IF statement, which should fix your formatting trouble.

IF({amount of discount}<0, {amount of discount})

See Solution in Thread

2 Replies 2
Kamille_Parks
16 - Uranus
16 - Uranus

The outcome is considered a string because a possible value based on your formula is a space character, instead of BLANK(). You could simplify your formula to just be your nested IF statement, which should fix your formatting trouble.

IF({amount of discount}<0, {amount of discount})

Michael_Arsenau
4 - Data Explorer
4 - Data Explorer

That worked perfectly

Thanks