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?
Solved! Go to 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
@DavidSkaife Thank you so much. i kept using "isnull" and it wasnt working. IF ISEMPTY worked!
You're very welcome :)