How to blank Rows using Multi-Row Formula

[Yawer]

I want to know how can I use the Multi-Row Formula to blank the below row 

as you will see the desired output in the sheet and you can see the output in alteryx

[IraWatt · Accepted solution]

Hey @Yawer,

Sure you can do it with a formula like this:

IF [Row+1:ATM stop dispensing] != NULL() THEN NULL() ELSE [ATM stop dispensing] ENDIF

If you want to learn more about the Multi-Row-Formula Tool the community has some quick and easy videos on the topic here: https://community.alteryx.com/t5/Interactive-Lessons/Multi-Row-Formula/ta-p/82872

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

[Yawer]

@IraWattThank you so much. It really helps.

[IraWatt]

No worries @Yawer 😄 have a good one!