Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Gian Paolo,
this is doing it for me, I am seeing the same results as in the previous changes that I had done
add into your script a regular date format and then create a variable that reads your max and min date and add that into your set analysis
sum({<FV_Tipo=,YearMonthDate = {'>=$(=(vMinCurrentDate))<=$(=(vMaxCurrentDate))'},>} FV_Imponibile)
this document should help also
Hi Ramon,
thanks but don't work ...
Please you can enter a formula in my example?
Thanks again ....
Gian Paolo
I misunderstood your requirement, you are already doing what I was suggesting
but have you tried using the column number identifier, instead of your current formula ?
this is the expression
(rangesum(above(column(1)&' ' ,0,12)))
/
rangesum(above(column(2),0,12))
and this is the result
Mese | 2015 | 2014 | Diff | Diff % | New Metric |
---|---|---|---|---|---|
€ 129097.90 | € 241611.70 | -€ 112513.80 | +53.4% | 53.43% | |
gen | € 56650.00 | € 147613.70 | -€ 90963.70 | +38.4% | 38.38% |
feb | € 87132.90 | € 219006.70 | -€ 131873.80 | +42.7% | 39.79% |
mar | € 129097.90 | € 241611.70 | -€ 112513.80 | +185.6% | 53.43% |
Hi Ramon,
sorry but I explained bad ... we try again.
Sheet "Sales Report"
Object "Budget"
Last column
I select all of 2013, 2014 and 2015.
In the last column I want the following result.
Today we are in April and I would like the difference in % of sales between the months of January February March 2015 VS January February March 2014.
In May I would like the difference in % of sales between the months of January February March April 2015 VS January February March April2014.
Thanks.
Gian Paolo
what do you expect to see in Jan?
Hi Ramon,
look this formula:
(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))
Is almost correct but I want today April I make a comparison between the first three months of 2015 versus the first three months of 2014.
As it is now compares the first 3 months of 2015 with the end of 2014 and it is not what I want.
it is clear ... thanks
Gian Paolo
Hi Ramon .....
or better the formula works if I enter dimension "MONTH" and I become the first.
But if I enter this dimension "MONTH" throughout the grid changes and it is not what I want.
Thank You.
Gian Paolo
so i replaced the accumulation calculation that was being done in the first two columns with your expression and then applied the formula that I believe you wanted to add in
attached is the document
thanks
Hi Ramon,
I saw that you made changes to the object "Sales Report" of the sheet "Sales Report".
But that's okay.
The last column
I want to change the last column of the grid the object's Budget in the sheet "Sales Report".
OK?
Thanks