If condition based on another column

[Ame]

Hi, I have two columns named Object and Address, and I want to edit the script editor to give me results, If Object has an address show me 1, and if the Object doesn't have an address(if its null) show me 0,
How can I do that?
 Thanks in advance!

[anushree1]

Ideally something like below must help ,if not please share the data

if(len(trim(address))>0 and isnull(address)<>0,1,0) as Flag

[NitinK7]

hi Samri,

try to use below expression this could be help you

If(GetFieldSelections(object)>1 and Len(Trim(address))<>0,1,0)

Regards,

Nitin