Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try this:
Num(RangeSum(Above(Count({<STARTDATE= {"*2016*"}>} ID), 0, RowNo()))/RangeSum(ABOVE(Count({<STARTDATE= {"*2016*"}>} ID), 1, RowNo())) - 1, '#.00%')
Sample attached