Hello all,
I'm comparing values within a column, this is what it looks like on excel:
The formula used for count is: =IF(A2<>A1,1,0) and it progresses through the cells as shown in the image.
How can I do this on Alteryx. I've tried using the formula tool, but I can't figure out how to express it.
Thanks in advance.
Solved! Go to Solution.
Hey @Eneye,
To compare different rows with a formula you can use the multi row formula tool:
If you want to learn more about the Multi-Row-Formula Tool the community has some quick and easy videos on the topic here: Interactive-Lessons Multi-Row-Formula
Any questions or issues please ask :)
HTH!
Ira
Thanks, works perfectly!
No worries @Eneye 😄