Between Years Comparison

[agomes1971]

Hi,

is it possible to create an expression from a set analysis that compares one year with the previous?

Please see attached.

Thanks

[MK_QSL]

Current Year

SUM(Sales)

Previous Year

SUM({<Year = {'$(=Max(Year)-1)'}>}Sales)

[ecolomer]

Try this:

sum({$ < Año={$(=max(Año)-1)} > } Ventas)

where Año (=Year) is the maximun year selected

[maxgro · Accepted solution]

if you mean this the expression is

Sum({$<Year={">$(=max(Year)-5)<=$(=max(Year))"}>}Vendas)/1000

-

above(Sum({$<Year={">$(=max(Year)-5)<=$(=max(Year))"}>}Vendas)/1000)

[agomes1971]

Almost that.

The expresssion I needed was:

(Sum({$<Year={">$(=max(Year)-5)<=$(=max(Year))"}>}Vendas)/1000

-

above(Sum({$<Year={">$(=max(Year)-5)<=$(=max(Year))"}>}Vendas)/1000))/

above(Sum({$<Year={">$(=max(Year)-5)<=$(=max(Year))"}>}Vendas)/1000)

but without your contribution it could not be possible.

Thank you so much

André Gomes