on 01-25-2017 6:49 AM
Hi All,
i am applying a logic like:
if("Material"='xxx' or "Material"='yyy' and ("Type"='261' or "Type"='262'), "Qty",0)
In the above case i want to display Quantity if Either of the Material and Either of the Type is true. Both of the conditions before and after AND must satisfy.
But the result i am getting is considering only Material even if the Type is different, for eg
Material Type Qty (Wrong)
xxx 101 5000
Material Type Qty (Correct)
xxx 262 1000
Please help me if i am missing something.
Regards
Vaibhav
I think you have to enclose the Material conditions also in brakes, otherwise if the Material is 'xxx' the further conditions are not considered anymore. At the moment the Type conditions are only applied in case the Material is 'yyy'.
if(("Material"='xxx' or "Material"='yyy') and ("Type"='261' or "Type"='262'), "Qty",0)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.