Sum with set analysis

[#1]

Hi,

I have the following expression: sum(AVAIL_1)/sum(AVAIL_2)

the result of this expression bring to me the sum of all avails from all weeks, but I need to filter just the avails of the last four weeks (SEMANA)

i wrote the following:

sum({< SEMANA = {'>$(=max(SEMANA) - 4'}>} AVAIL_1)/sum({< SEMANA = {'>$(=max(SEMANA) - 4'}>} AVAIL_2))

but doesn't works.

How can I fixe this?

Thank you!

[salto]

Hi Rafael,

this works for me:

sum({< SEMANA = {">=$(=(Max(SEMANA) - 4))"}>} AVAIL_1)

/

sum({< SEMANA = {">=$(=(Max(SEMANA) - 4))"}>} AVAIL_2))

Hope this helps!

[javier_florian]

You can try with this:

=Sum({<Semana={">=$(=Num(Max(Semana))-2)<=$(=Num(Max(Semana)))"}>} Avail_1)

/

Sum({<Semana={">=$(=Num(Max(Semana))-2)<=$(=Num(Max(Semana)))"}>} Avail_2)

Regards,

- Javier Florian