Formula or Multiformula Tool

[Cferrer6]

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?

[davidskaife · Accepted solution]

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 :)