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

Sold-to account

Outcome:

Parent Account

Sold-to account

Are you able to help me on this please?

Thanks

Workflow

Datasets

Tips and Tricks

Common Use Cases

Best Practices

Data Investigation

Accepted answers

geraldo

@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

All comments

gautiergodard

Hey @LM_APAC2023

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

geraldo

@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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703