% Increase in combo chart

[Anonymous]

I have a chart and I would like to take last month and compare the the totals of the months after. For example 201605 to 201606 % increase from 18 to 49 is not 72% and 49 to 71 is definetly not a negative increase. Confused on what I'm doing wrong. I have attached a sample app.

[sunny_talwar]

Try this:

Num(RangeSum(Above(Count({<STARTDATE=  {"*2016*"}>} ID), 0, RowNo()))/RangeSum(ABOVE(Count({<STARTDATE=  {"*2016*"}>} ID), 1, RowNo())) - 1, '#.00%')

[sunny_talwar · Accepted solution]

Sample attached