Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi Rafael,
this works for me:
sum({< SEMANA = {">=$(=(Max(SEMANA) - 4))"}>} AVAIL_1)
/
sum({< SEMANA = {">=$(=(Max(SEMANA) - 4))"}>} AVAIL_2))
Hope this helps!
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