5 Replies Latest reply: Jan 25, 2016 1:13 PM by Filipe Lima RSS

    Set Analysis - Using variables for comparison

      Hello,

       

      I'm trying to use variables on a count aggregation but it's not working

       

      COUNT({< vIntervalo = {'>500'}>}CLIENTE)

       

      when vIntervalo is SUM({<MOTIVO ={ 'NOR'  }>} VALOR_BX )

       

      My goal is to show the CLIENTE (customers) counting that vIntervalo (sales) is bigger than 500.

       

      I've been triend many syntaxes and also created a second variable with 500 content.

       

      Appreciate any help.

       

      Tks