Need to Update Active Row and Row -1

[patz007]

Hi Experts,

I wanted to update a field for two rows. Like

IF [Col2] = 0 THEN [Test] = 1 AND [Row-1:Test] = 1 ELSE 0 ENDIF

Can I update the formula like this it is giving me an error?

Thanks 

I really appreciate the help and support.

[DataNath]

You can’t define the current row for your new field, only +/-. For the example you’ve provided there you should just need to take out the ‘[Test] =‘, so:

if [Col2] = 0 then 1 and [Row-1: Test] = 1 endif

[messi007]

@patz007,

Please see below :

Attached the workflow,

Regards,

[binu_acs]

@patz007 

[patz007]

@messi007,

I tried your solution but it is not working as accepted. Please review the screenshot below.

Please let me know how I can achieve this.

[patz007]

@DataNAth

I tried your solution too but it is giving me all zeros.

Please let me know if there is anything else I can do.

I really appreciate the help and support.