This content has been marked as final. Show 1 reply
I think that the issue you are facing (though you don't post any error message or what) comes from a data type conflict.
If I were you, I would make sure that all the data is FLOAT (because you're comparing with floating numbers).
This would look like this if you remove the *1.00 which stands for a null operation and make sure you're comparing FLOATs with FLOATs :
CASE WHEN (CAST("- Custom Number/Integer".S_NUM_1 AS FLOAT) >= CAST('8.5' AS FLOAT))
THEN CAST('8.5' AS FLOAT)
ELSE CAST("- Custom Number/Integer".S_NUM_1 AS FLOAT)