4 Replies Latest reply: Dec 27, 2011 8:54 AM by washington alex RSS

    ValueList x Set Analysis

    washington alex



      I am using this function:                                                                             



      = IF(ValueList('Atual', 'Anterior','Variacao_Vertical') = 'Atual',

      sum( {$<MES_ANO ={'$(vMesAtual)'}>} DISTINCT VALOR_PEDIDO),

      sum( {$<MES_ANO ={'$(vMesAnoAnterior)'}>} DISTINCT VALOR_PEDIDO))


      I'm finding it very heavy.


      Is there any way to add the "valuel" within the SetAnalysis?



      sum( {$<MES_ANO ={'$(vMesAtual)'}, ValueList = {'Atual'}>} DISTINCT VALOR_PEDIDO )