Skip to Content
Former Member
Feb 28, 2011 at 12:08 PM

Formula field that looks at more than one value - Item Group number


Hi Experts,

I hope you're all well.

I'm hoping you can help me with something I'm doing with my PLD please.

I am setting up my Sales Quotation PLD only prints out Items which belong to a certain Item Group, for example only Items belonging to Item Group 100. I made a formula field which says F_XXX==100 which works perfectly.

Now what I want to do is set up a formula field that doesn't only look at Item Group 100, but which also looks at Item Groups 137, 151, 175, 187, 189.... do I have to set up a seperate Formula field for each of these Items Groups or is there a way to make a formula field which can look at all of these Item Groups together please?

Many thanks for any help.