Hierarchy Logic Formula

Question

Hello - I am attempting to write a formula that would create a new field.

These are the following fields: Z2, Primary Group, Customer

The logic would be: If Z2 is not null then Z2, If Primary Group is not null then Primary Group, If both Z2 and Primary Group are null then Customer. How could I write this formula?

atcodedog05 · Answer

Hi @KRSANCHEZ

You can use formula like below

IF !IsNull([Z2]) THEN [Z2] 
ELSEIF !IsNull([Primary Group]) THEN [Primary Group] 
ELSE [Customer] ENDIF

Workflow:

Hope this helps : )

Group.yxmd

fmvizcaino · Answer

Hi @KRSANCHEZ ,

IF isnull(Z2) and isnull([Primary Group])

Then Customer

elseif !isnull(Z2)

then Z2

elseif !isnull([Primary Group])

then [Primary Group]

else null()

endif

Best,

Fernando V.