12 Replies Latest reply: Jun 1, 2009 6:05 PM by Joaquim Martínez RSS

    Using set analysis with variables

      Hi,

      I have a table Fact: Concept, Month, ValueEUR

      And another table AuxTime: AuxMonth

      I use the set analysis expression below:

      Sum($<[Concept] = {'RESULTADO'} , [Month] = {'$(=MaxString([AuxMonth]))'}>ValueEUR)

      If I use this expression directly in a Chart, the expression works right. However, if I create a variable and then I use the variable in the Chart, it doesn't work. The expression becomes

      Sum($<[Concept] = {'RESULTADO'} , [Month] = {''}>ValueEUR)

      What I do wrong?