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

    Aggr sum and set analysis expression problem


      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.


      Bruno Silva.