This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hi Community! I decided to ask for help after trying many variations for my formula with multiple conditions without any success. It does not give me error message, but when I validate the results, it just not correct. I will write in english what I want to achieve.
1. if order status contains 'work complete' or 'invoiced' return value "0"
2. if Main work center contains 'CANC' or 'Schedule' then return "0". But in any other case (only true for the 2nd condition), additionally if the System status contains "Closed" only then return "1"
Every other case (including condition 1) return value "1"
if (!Contains([Order Status],"Work Complete","Invoiced") && Contains([Main work center], "CANC","SCHEDULE")) THEN "0" ELSE "1" ENDIF - I got until this point but it already didnt work...without including the System status condition.
I hope it is understandable , and someone can help me resolve this.
Here's a rough example of what I think you're looking for. I assumed in the below formula that if [System Status]='Closed' then it wouldn't matter what other conditions were fulfilled, you would just want it to be 1. If that's not the case then let me know and I can help you adjust.
IF [System Status]="Closed" THEN 1 ELSEIF
Contains([Order Status],"Work Complete") OR Contains([Order Status],"Invoiced") THEN 0
ELSEIF Contains([Main Work Center],"CANC") OR Contains([Main Work Center],"Schedule") THEN 0
ELSE 1 ENDIF
this looks I believe really good but I have a few problems with it when I run.
First of all let's disregard the System status condition entirely.
Regarding the rest of the formula, when I put into the same formula box, either to every row returns 0 value, or some rows just simply incorrect - after validating them 1 by 1.
So I figured I am going to put into 2 separate box by splitting the conditions based on the field that it the formula is looking at (order status,main work center) but it also doesn't work properly because 1 overwrites the other.
I am a bit confused what should I change in the formula. I might add more to the query that I missed to mention before. First of all the formula should look at the Order status field if there is Work complete or Invoiced. If none of the above is true then look at the Main Work center column and return 0 or 1 based on the formula. The reason for this is that Order status column might be Null sometimes, so then I need the formula to look at the Main Work Center column.
Hope this is not too complicated. let me know please if you need anything else in order to be able to resolve it.
Thank very much Roland. Also, thanks for all of you trying to help me.
I needed this re-organization also in my main formula but it works now perfectly!
General experience with Alteryx that many user lacks from basic knowledge. Personally,I could not find good training materials about basic principles,how Alteryx differs from excel for ex. when it comes to i.e. formulas,e tc.. only explanations about how every tool work. In case you would recommend material that I can go through , it would be highly appreciated!