IF formula creating double entries

[LM_APAC2023]

Hi all,

I want to fill the null entries under family account (tier 1) with the respective sold-to account (tier 2). However, I am facing below problem with my IF formula:

Applied formula: IF IsEmpty([Family Account]) THEN [Sold-to account] ELSE [Family account] ENDIF

Problem: Formula is adding an additional family account entry under sold to:

Before:

Parent account

AB

Sold-to account

BB

Outcome:

Parent Account

AB

Sold-to account

BB

AB

Are you able to help me on this please?

Thanks

[gautiergodard]

Hey @LM_APAC2023 

Would you be able to share your workflow or a representative equivalent if it contains sensitive information?

[geraldo · Accepted solution]

@LM_APAC2023 

If it still doesn't resolve make this adjustment

 IF IsEmpty(Trim([Family Account])) or  IsNull(Trim([Family Account])) THEN [Sold-to account] ELSE [Family account] ENDIF

[LM_APAC2023]

Thanks a lot, Bolide!

This has done the trick.