2 Replies Latest reply: Oct 22, 2012 4:36 AM by Adolfo H

Indirect Set Analysis

Hello,

I need some help

I want to get customer for the current selection but I want exclude customer who bought and item and cutomer who bought items from a brand.

Expression 1:

Sum({\$<COD_TARJETA-=p({1<COD_ART={\$(Articulo_excluir)}>}COD_TARJETA)>}IMP_VTA_LINEA)

Expression 2:

Sum({\$<COD_TARJETA-=p({1<COD_MARCA={\$(Marca_excluir)}>}COD_TARJETA)>}IMP_VTA_LINEA)

COD_TARJETA = Customer

COD_ART = Item

Articulo_excluir=Item to exclude

IMP_VTA_LINEA=Sales

COD_MARCA=Brand

Marca_excluir= Brand to exclude

Every expression works fine.

But get both exclusion in only one expression does not work. I use:

=Sum({\$<COD_TARJETA-=P({1<COD_MARCA={\$(Marca_excluir)}>}COD_TARJETA),COD_TARJETA-=P({1<COD_ART={\$(Articulo_excluir)}>}COD_TARJETA)>}IMP_VTA_LINEA)

Any idea

Thanks

• Re: Indirect Set Analysis

You have two different set modifiers for field COD_TARJETA, this will not work as expected.

Try like

=Sum( {\$<

COD_TARJETA =

COD_TARJETA -

(

P({1<COD_MARCA={\$(Marca_excluir)}>}COD_TARJETA)

+ P({1<COD_ART={\$(Articulo_excluir)}>} COD_TARJETA)

)

>} IMP_VTA_LINEA)

• Re: Indirect Set Analysis

Thanks swuehl

It works

So simple...