Expression Probleme

[Ayoub]

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 😄

[edwin]

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