Forum Discussion
gpiero
9 years agoSkilled Sharer
Operators AND - OR in Nested IF
I am struggling with a silly formula but I am not able to find the proper solution. I know it should be easy ..... CS_Universe =
IF (
ZV[OrgCom] = "CUSTORG"
&& ZV[IDCust] = "491"
...
- 9 years ago
Many thanks for your advices.
I tried to split in 4 different columns. Doing that I realized that 1st IF should have a differente logic:
IF ( ZV[OrgCom] = "CUSTORG" && ZV[IDCust] = "491" && ( ZV[IDDel] = "SPD99" || ZV[IDDel] = "WAR99" || ZV[IDDel] = "DPD99" || ZV[IDDel] = "FOC99" || ZV[IDDel] = "KBD99" ) && (ZV[CounFinGood] <> "MX" && ZV[CounFinGood] <> "RU" && ZV[CounFinGood] <> "AR" && ZV[CounFinGood] <> "CN"); "1CS";Now I have changed the orginal long formula and it is ok.
Thanks again.
Framet
9 years agoResolver II
You mention the formula works perfectly except the second IF. I'm assuming at somepoint you are expecting the result "2CS" but getting something else. What is that something else?
gpiero
9 years agoSkilled Sharer
I get nothing.
While using the calculation of the 2nd column added for test COUNTROWS finds 91 rows and tha value is ok due I checked it via ERP.