Percent Change Combo Chart

[Anonymous]

I have the below expression in a combo chart

=If(STARTDATE_YYYYMM >= Max(TOTAL STARTDATE_YYYYMM, 6), Below(RangeSum(Below(Count({<STATUS = {'Open'}>}ID), 0, NoOfRows() - RowNo() + 1))) + Count(ID))  Works Perfectly!

Now I would like to create a line chart that shows a percent change from month to month.

201607 should be 3.8 %    % difference between 49,910 and 48,006

201606 - 8.17 %

[sunny_talwar · Accepted solution]

May be this:

=If(STARTDATE_YYYYMM >= Max(TOTAL STARTDATE_YYYYMM, 6), Below(RangeSum(Below(Count({<Status = {'Open'}>}id), 0, NoOfRows() - RowNo() + 1))) + Count(id))

/ If(STARTDATE_YYYYMM >= Max(TOTAL STARTDATE_YYYYMM, 6), Below(Below(RangeSum(Below(Count({<Status = {'Open'}>}id), 0, NoOfRows() - RowNo() + 1))) + Count(id))) - 1