Fix percent change for total row in matrix

[ysherriff]

Hi all,

Can someone help me with the formula to calculate the correct percentage change for the total in a matrix? For example, in the image below the QTD is $2.1B and Prior QTD is $2.08B which should show 5% QoQ change not 8%.

Can someone help.

[Migasuke]

Hi @ysherriff ,

QoQ % should be calculate something like this:
QoQ % change = DIVIDE([Quarter Over Quarter measure],[Quarter-to-Date measure],0)

In case, you would like to write precise formula, please share the table name and columns.

[ysherriff]

Hi below are the measures I am using for the calculation. This is done via tabular editor. I am trying to get the following results:

Desired Result

Image #1- QTD

Image #2 - Prior QTD 

Image #3 - QoQ change

Image #4 - QoQ % Change

[Migasuke]

Hi @ysherriff ,

my logic then remains the same, I have just adjusted the name of the measures.
Please try it and let me know:

QoQ % change = DIVIDE([QoQ change],[QTD],0)

[ysherriff]

Thanks but I have that formula. I know how to calculate QoQ% but the totals are incorrect. I am using the following formula to get the total but it is incorrect.