Hello, how can i get this result in formula tool where row=row-1 then "Y" other wise "N" IDFormula1AN1BY1BY1CN1DN1EY1EY1FY1FY1GN1HN

How to formula based on Row-1

Hello,

how can i get this result in formula tool where row=row-1 then "Y" other wise "N"

Developer

@kauser one way of doing this

@kauser one way of doing this

We'll need some more information - are you doing this per ID? What is the expected result from this data?

Either way, you can look at the MultiRow Formula tool for anything Row-1: Multi-Row Formula Tool (alteryx.com)