Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Thank you very much, Clever Anjos! It worked just perfect!
I don´t understand the data model either! As I said before, It wasn´t me that developed the qvw. And I really think that the model is a mess, but I was told that the business is very complex... I didn´t had the time to analyze it!
Thanks again for your help!
Best Regards,
Bruno Silva.