Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Community it's been a whiiiile ,
I'm facing a little problem Here, i hava table called Pack which have 3 Fields : Code,Product, Price,
The Product can take Multiple Value : A,D,R,P,B,C,D,E,F,G,H,I
and I shoudl Dress A table Which can tell me Wish Formul is this Pack:
Form 1 : B
Form 2 : B+C+(D or E)
Form 3 : B+C+(D orE)+(F or G )
Form 4 : B+C+(D orE)+(H or I )
i'm dealing with this prob since yesterday and i couldn't get the result i wan't , If someone could Help !
Thank you Before 😄
try this for form 4:
=count({
<Prod=p({<Value={'B'}>}Prod)>*
<Prod=p({<Value={'C'}>}Prod)>*
<Prod=p({<Value={'D','E'}>}Prod)>*
<Prod=p({<Value={'H','I'}>}Prod)>
}
Prod)
so its just a matter of combining AND statements. see attached. if there are heirarchies to your rule, you can create IF statements based on the 4 expressions