Combo Chart Expression % Change

[Anonymous]

I'm having issues with my line chart expression. I'm trying to create a % change from month to month but my percentages are incorrect. If someone can help, great. But could you also explain to me what I'm doing incorrectly? Thanks.

I want to see the % change from month to month and my values are incorrect.

[sunny_talwar]

What are the numbers you are expecting to see John?

[Anonymous]

For the line chart, % Change from month to month. All other values are correct.

201608 would be 5.6% decrease The difference between 54,087 and 51,061

201607 would be 7.2% decrease. The difference between 58,280 and 54,087

[sunny_talwar · Accepted solution]

Try this:

If(RowNo() <= 6, Num(Count({<[Start Date Month] = {"*201*"} >} Member)

/

Below(Count({<[Start Date Month] = {"*201*"} >} Member), 1) - 1, '#.00%'))