Calculated field

[DavidMetodoyEmocion]

Hi

I want to add a new field in order to check if other field (Field1) is null or not.

• If  Field1 is null, then the calculated field value must be "1"
• If  Field1 is not null, then the calculated field value must be "0"

Can you help me with the formula?

Thanks a lot!

D

[Taoufiq_Zarra]

If I understood correctly

=if(isnull(Field),1,0)