5 Replies Latest reply: Sep 9, 2014 3:59 AM by Prashant Sangle RSS

    Problem with variable in set analysis

      I am trying to evaluate one of two expressions, but neither works:

       

      =Sum({1<cod_annomes ={$(#indicador1)}>}  valor) [variable indicador1 = annomes&'AT-1a', and works perfectly)

      OR

      =Sum({1<cod_annomes =annomes & {'AT-1a'}>}  valor)

       

      But if it works...


      =Sum({1<cod_annomes ={'201409AT-1a'}>}  valor)


      Is it an error syntax? Can i use a varible in an expression with set analysis?

      Thanks in advanced, i tried all that i know and read a lot of questions of this forum...


      Greetings