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

    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