Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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.

10 Replies
Not applicable
Author

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.