How to make my % row display 51% instead of 77% ?

[#1]

Hi All

I have a straight table . the first row summary % display wrong value. How to make it display 51 % ? if i set the total mode = Average , it display 77% also wrong.

Expression :-

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

[#2]

Hi All

Below is the link of my QV QVW file :-

Dropbox - sales drop percentage wrong.qvw

[tresesco]

Without sample app it is hard to match your expected number. Could you post your sample app?

[#4]

Hi tre

already posted . but need modulator approval before it can post.

Paul

[#5]

Hi tres

Thank you very much for your response.

Enclosed is my QV Doc.

Paul

[phaneendra_kunc]

seems document is corrupted. not able to open.

please repost the QVW.

[#7 · Accepted solution]

Hi Sir , As i try to prepare for the the new QV Doc , i found out that my QV doc is working fine now , hank u for your he,p