Problems with time interval month

[#1]

Hello everyone,

little problem with a formula

Sheet "Sales Report"

Object "Budget"

Last column

I want to calculate the% increase in 2015 vs. 2014 but the same period.

The interval must be selected every month and in 2013, 2014 and 2015.

I want the value in%, for example, today April the ratio between January February March 2015 versus January February March 2014 .... and so on   ...   in May the ratio of January February March April 2015 versus January February March April 2014

Someone can help?

I attach files.

Thank You.

Gian Paolo

[ramoncova06]

Try with these formulas

sum({<FV_Tipo=, Anno={$(vMaxAnno)},Annomese = {"<=$(=(max(Annomese,2)))"}>} FV_Imponibile)

sum({<FV_Tipo=, Anno={$(vMaxAnnoPrec)},Annomese = {<=$(=date(AddYears(max(Annomese,2),-1),'YYYY/MM'))"}>} FV_Imponibile)

you can switch the advanced search to variables

[#3]

Hi Ramon, these formulas don't work ... sorry and thank you.

I would use the formula below but it does not work ... I also tried to replace, with 0.12, 0.3, (jan - mar) but the result does not change any other ideas?

(rangesum(above(sum({<FV_Tipo=, Anno={$(vMaxAnno)}>} FV_Imponibile),0,12)) - rangesum(above(sum({<FV_Tipo=, Anno={$(vMaxAnnoPrec)}>} FV_Imponibile),0,12))) / rangesum(above(sum({<FV_Tipo=, Anno={$(vMaxAnnoPrec)}>} FV_Imponibile),0,12))

The values in red indicate all 12 months?

and if you want only the first 3 months? I tried to put, 0,3 but the result does not change ...

Thank you ....

Were are you from? 

Gian Paolo

[Anonymous]

Maybe!

[ramoncova06 · Accepted solution]

Gian Paolo,

this is doing it for me, I am seeing the same results as in the previous changes that I had done

[#6]

Hi Ramon,

seems to work!!!!

Thanks for your patience and availability ....

Gian Paolo