10 Replies Latest reply: Feb 27, 2014 5:27 AM by Bruno Silva RSS

    Aggr sum and set analysis expression problem

      Hi.

      I´m having problems with an Aggr expression.

      To selected year, it works fine, but when I use the same expression, just switching the set analysis to return resuts to previous year, it doesn´t return values.

      Variables are returning the years correctly.

      To current year: Aggr(sum({$<Ano={$(vcurrentYear)}>}Aggr(valor, idProdutoReservadoValor,Ano)), [Nome Social]) - This works fine!

      To previous Year: Aggr(sum({$<Ano={$(vPreviousYear)}>}Aggr(valor, idProdutoReservadoValor,Ano)), [Nome Social]) - Returns 0.

       

      Any ideas?

       

      Thanks in advance.

      Regards,

      Bruno Silva.