Formula or Multiformula Tool

Hi all,

I have data (shown on screen shot attached) where i have missing "customer #s" and i would like to take the "customer #" from above and fill in the missing one. i feel like i can use the multi row formula but i cant figure out the expression. Any ideas?

2022-03-28_14-56-01.png

Developer

Tips and Tricks

Accepted answers

davidskaife

Hi @Cferrer6

In it's simpliest form you can use IF ISEMPTY([Customer #]) THEN [Row-1:Customer #] ELSE [Customer #] ENDIF

Replace the ISEMPTY part with ISNULL as required depending on the way Alteryx is treating that field

All comments

davidskaife

Hi @Cferrer6

In it's simpliest form you can use IF ISEMPTY([Customer #]) THEN [Row-1:Customer #] ELSE [Customer #] ENDIF

Replace the ISEMPTY part with ISNULL as required depending on the way Alteryx is treating that field

Cferrer6

@davidskaife Thank you so much. i kept using "isnull" and it wasnt working. IF ISEMPTY worked!

davidskaife

You're very welcome

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703