Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Ok forum need your help. I have a screen where I want to show customers who have purchased a material group (selected by the user from a dropdown list), but not this material group (selected by the user from another dropdown list). Can anyone help out there or give me an example?
Thanks
Thom
Did you try the P() and E() functions in set analysis??
I have been looking at them, but not too sure on how to code it because it's based on what the user selected from the list boxes. I have an example Sum({$<Customer = (P({1<Product = {'A'}>})) * (E({1<Product={'D'}>}))>}Sales). This is the example I am trying to work with but I don't understand what I would put in the product 'A' or 'D' because these are fields the user would select.
Thanks
Ok. I have tried these stmts with no luck. Could someone please explain what these statements are doing vs what I think they are doing?
sum({$<[Ship To] = p({$<[Material Group Code] ={'002'}>} [Ship To])>} [Subtotal 1] + [Subtotal 2])
sum({$<[Ship To] =E({1<[Material Group Code] ={'010'}>} [Ship To])>} [Subtotal 1] + [Subtotal 2])
sum({$<[Ship To] = P({1<[Material Group Code] ={'002'}>}) * E({1<[Material Group Code] ={'010'}>} [Ship To])>} [Subtotal 1] + [Subtotal 2])
Thanks
Thom