Indirect Set Analysis

[#1]

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

[swuehl · Accepted solution]

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)

[#3]

Thanks swuehl

It works

So simple...