Using include- exclude in set analysis

[jjking58]

Hi,

I have a two part question.

is it possible to use the following to list excluded customers for the current selection with the exception of year and month

(sum({$<CustomerName= E(CustomerName),fYear=,FMonth=>} PartsAmt) +

sum({$<CustomerName= E(CustomerName),fYear=,FMonth=>} EqupAmt) +

sum({$<CustomerName= E(CustomerName),fYear=,FMonth=>} LaborAmt))

Also can you have more then one (E) in the same expression

Thanks in advance

[effinty2112]

Hi Jim,

The E() function in not intended for this, more like

Sum({$<Customer = E({<Product = {'Shoe'}>})>}Sales)

gives the value of Sales for customers that have never bought a shoe.

To exclude from the current selection try something like:

sum({1-$}PartsAmt)

if you have only made selections on the field Customer then this might be what you need

Regards

Andrew

[jjking58]

Andrew thanks for the response, but i want to include the current selections with the exception of year and month.

Using  {1-$}PartsAmt) totally ignores all  current selections. I want to show a table of what was not purchased based on the selection