Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.

Simple Muti-Row formula help needed

5 - Atom

Hi All,

 

EDIT NEVERMIND: I FOUND MY SOLUTION : https://community.alteryx.com/t5/Alteryx-Designer-Discussions/If-all-values-are-true-for-an-option-t...

 

I'm using the muti-row formula tool to solve my problem, I simply want Alteryx to go down a column and detect if any value is False it returns 0 for all rows.

 

Below is my desired output for the conditions.

Variable | Returned value

True0
False0

 

False0
False0

 

True1
True1

 

 

So far, I have tried 

 

if [variable] = [Row-1:variable] then 1 else 0 endif

 

but this doesn't work as it returns a 

 

True1
False0

 

Thank you!

 

Alec

Labels