Not able to use IF condition for NULL rows

[haneeshmarella]

Hi guys,

I have a field called CONTAINER. If it is NULL, it is OFFLINE and if it is NOT NULL, it is ONLINE. I've tried multiple IF conditions to get the options of ONLINE and OFFLINE based on the data but OFFLINE never shows up although there are NULL values in that field.

If(CONTAINER IS NULL,'OFF-LINE','ON-LINE')

If(CONTAINER = ' ','OFF-LINE','ON-LINE')

If(CONTAINER LIKE '%99%','ON-LINE','OFF-LINE')

If(CONTAINER <> ' ','ON-LINE','OFF-LINE')

IF(ISNULL[CONTAINER],'OFF-LINE','ON-LINE')

Can you please help me what minute mistake am I making? Also, any alternative like loading them separately?

[sunny_talwar · Accepted solution]

Try this

If(Len(Trim(CONTAINER)) = 0, 'OFF-LINE', 'ON-LINE')

[haneeshmarella]

Thank you Sunny