I am making an analysis in AF and I want to select an output that could be one of three things depending on what information is coming in. I am used to doing this in excel, but not in this slightly different function language.
What would be the correct way to say something like the following.
Anytime attribute 1 is good, I want to bring in data directly.
If attribute 1 is bad, then I check attribute 2 and depending on if that is bad I either substitute a zero in place of the incoming data, or I tell pi not to record the data.
So I have done a test previously for Attribute 1 and Attribute 2. Attribute 3 is the value I actually want to record if it is good
IF(att 1 = 1) then(Att 3) ELSE(IF(Att 1 = 0 AND Att 2 = 0) THEN 0 ELSE (nooutput())
I am open to other methods of doing this completely.