Hey everyone, I have a situation where I have a locked bundled field that is a text field. I'm trying to convert that field into a decimal/currency value. I'm then trying to compare the item rate field to this TP price field. I used the to_number function to convert this. But I seem to have an issue with the case statement, that I can't figure out. Any help would be greatly appreciated.

From the screenshot you are comparing 5.65 = 5 which is FALSE and returns 0. What is the comparison you want?

oh wow, that was kind of embarrassing. thanks for pointing that out. I appreciate the second set of eyes. clearly doing too many things at once.