Error converting data type varchar to float

[imJihyo]

Hello guys! Just wanted to know if anyone already encountered this error on formula field when making case when formulas?

"Error converting data type varchar to float"

I'm trying to make a very simple case when formula but I keep getting that error. I tried to use the same formula in calculated fields but I just got a normal "Invalid formula" error.

 

Case
When ([@field:ItemPrice]) > 500 and([@field:ItemPromo]) = 'Half Price'
then [@field:ItemPrice]/2
else 'Original Price'
End

Any help will be much appreciated!

- Jihyo ♥

[ParkLoey]

Hey @imJihyo! I encountered the same issue before and it was all because my results were different data types. Try changing the result for ELSE to a number as well like, 0 or just use [@field:ItemPrice]  

[PotatoMato]

Just to add, you may also convert the result of 'then' to text. For example:

Case
When ([@field:ItemPrice]) > 500 and([@field:ItemPromo]) = 'Half Price'
then CONVERT(VARCHAR,([@field:ItemPrice]/2))
else 'Original Price'
End

-Potato