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

    Set Analysis - Using variables for comparison



      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.