I'm using the Formula tool on the following type of data:
Acct
XXX-AAA
XXX-BBB
XXX-CCC
XXX-DDD
XXX-EEE
YYY-AAA
YYY-BBB
if the data has "AAA" (XXX-AAA and YYY-AAA are the targets) i want one result, if the data has "XXX" but not "AAA" then I want another result (the match is all the data starting with XXX except XXX-AAA)
i broke it up into two consecutive formula tools, the first one worked and went like this:
IF Contains([Acct], "AAA") THEN t ELSE f ENDIF
this worked, got the results i needed for XXX-AAA and YYY-AAA
but then i added a second tool and wrote like this:
IF Contains([Acct], "XXX") and !Contains([Acct], "AAA") THEN t ELSE f ENDIF
this is not working -- it does what i want with the XXX data but invalidates what i did with the AAA data in the first tool.
can i either write this all in one formula tool, or in consecutive tools such that the formula in the second tool does not invalidate the first tool's formula? I could probably split them out with a filter and then recombine, but this seems like too many steps.
