How to make my % variance display 18% ?

[paulyeo11]

Hi All

I have a striaght table , the top row unable to display the 18% .

See my enclosed image for more information.

[paulyeo11]

Enclosed my QV doc.

=if(column(1)=0,1,column(2) / column(1)-1)

Above expression are % var.

[Sokkorn]

Hi Paul,

Can you share expression [YTD Variant] here. Or you can give a try =(Column(2)-Column(1))/Column(1)

Regards,

Sokkorn

[narender123]

Hi Paulyeo

Try this one:

=(Column(2)- Column(1))*100 /  Column(2)

Thanks.

NArender

[paulyeo11]

Hi Sok

My expression as below :-

=if(column(1)=0,1,column(2) / column(1)-1)

[Sokkorn · Accepted solution]

Hi Paul,

Try to use "Total Mode" with "Sum". See picture below

Regards,

Sokkorn

[paulyeo11]

Hi Sok

Your reply is correct.

Not sure  why yesterday i cannot make it right now working fine.

Hi All

Many thank for your response.

it work now.

Paul