# 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 % increaseFruits | 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.

+ Add a Comment