Skip to Content
0
Jul 01, 2022 at 02:12 AM

NOT NULL is not working in calculated Column

229 Views

Dear HANA Experts,

I have created a calculated column and written the IF condition as

IF("WC_RTYFL" ='SO' AND (NOT IsNULL("WC_SRPNO")) AND "WC_SOSTA" ='CLOSED',1,0).

But NOT Is Null is not working. Some of the records having the WC_SRPNO as NULL, but it is returning as value 1. Can you pls suggest how to handle NOT NULL values.

image.png

image.png

Thanks.

Attachments

image.png (43.6 kB)
image.png (33.9 kB)