cancel
Showing results for 
Search instead for 
Did you mean: 
Subscribe

Hello SAP experts,

I need some help with IF statement in Lunch Pad 4.3. I'm trying to create calculated column showing letter "G" if value is > 500.

=if([object]>500, "G") - giving me ERROR - Problem converting '500,' to a float.

0 Likes
View Entire Topic
Yogananda
Product and Topic Expert
Product and Topic Expert

zulo
This should work, but make sure your object is a numeric type. If it is a string, you will need to convert it to a number first. Try using the following syntax:

=if(tonumber([object]) > 500, "G", "")