Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need a formula for a growth rate by year in a combo Chart:
Try sum(sales)/above(sum(sales))-1
May be this:
Sum(Sales)/Above(Sum(Sales)) - 1
Thanks,
But The formula don´t work and returns "error in expression".
Do you have a sample you can share?
Sorry, i´m new here. What kind of sample you want?
if(year=2011),sum(sales),if(sum(sales)>above(sum(sales))),((sum(sales)-above(sum(sales)))/above(sum(sales)))*100,((above(sum(sales)-sum(sales)))/above(sum(sales)))*100
or
if(sum(sales)>above(sum(sales)),((sum(sales)-above(sum(sales)))/above(sum(sales)))*100,(above(sum(sales))-sum(sales))/above(sum(sales)))*100)