Forum Discussion
Boolean IF Statements - Need Help
Hello I am trying to do a nested IF statement but keep arriving on an error: Here is the equation: PO Status = if(AND('PO Data'[Closed for Receipt Date]>'PO Data'[First Promised Date],'PO...
Oh yes I see, I think I was over-complicating it.... so now I have a different error:
Now, I cannot figure out what is happening 😅
My advice is that you try to check the code step by step. For instance, check if the first condition is working:
PO Status = if('PO Data'[Closed for Receipt Date]>'PO Data'[First Promised Date],1,0)
If it is, try to add another piece of code:
PO Status = if(AND('PO Data'[Closed for Receipt Date]>'PO Data'[First Promised Date],'PO Data'[ClosedCode]= "CLOSED"),1,0)
And so on...
Anyway, if you provide a piece of data with the structure of what you are trying to calculate, I could help you