This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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?
Hi @KRSANCHEZ ,
IF isnull(Z2) and isnull([Primary Group])
elseif !isnull([Primary Group])
then [Primary Group]
You can use formula like below
IF !IsNull([Z2]) THEN [Z2]
ELSEIF !IsNull([Primary Group]) THEN [Primary Group]
ELSE [Customer] ENDIF
Hope this helps : )