Formula

[Hi2023]

Hi,

I am needing help with a formula- I think it is right but it is not coming out correctly.

PR-ALT-STATE” column – KJ only needed to be populated if “OWN-STE” column does not equal “KJ”—

I put new column for PR-ALt-STATE  -IF [OWN-STE] != 'KJ' then 'KJ' else Null() endif

thanks in advance!

[BS_THE_ANALYST]

@Hi2023 if [KJ] != [OWN-STE] THEN [KJ] ELSE null() endif

[nagakavyasri · Accepted solution]