Percentage Increase spend over the years

Hello,

I am having a little trouble in finding % increase for every year from 2013 to 2016. For clarity see the table below:\

Table to calculate % increase
Fruits 2013 2014 2015 2016

Banana

-- 25000 -- 1000000

Mango

22546465 545464 4654 5464654
Dates 46546 -- 54654 4656
Grapes 45465 879879 79798 978897

These are random values for sales.

Intially I was using the following formula:

((If(Sum([Sales]) is null, 0 ,Sum([Sales]))) -  Sum([Sales]) OVER (Previous([Axis.X])))

/

(If(Sum([Sales]) is null,0,Sum([Total_Amount_of_Payment_USDollars])))

 

However the issue is, as you can see in the table, I donot have sales value for Banana for year 2013 and 2015, so in an ideal condition it should show me a 100% increase in 2014 and 2016. For this purpose I added a simple condition to my formula, however its not working as i want. Can someone help me in this regard?

TIA.

 

(2) Answers

Login