expression total and excel total not tie up

[gauthamchilled]

In the attached qlikview, the variance and variance % total is not tie up with excel calculations. can any one help?

Regards,

Gautham

[MK_QSL]

Looks like your QVW is empty.

[gauthamchilled]

sorry...attached the updated one now

[tresesco]

Your expressions do not tie. Try expression: =(column(3)/column(1))*100   for Variance%

[vinieme12]

Remember BODMASS

(column(2)-column(1))/ column(1)*100

earlier it was evaluating

1)Column 1 / Column 1 first then

2)  * 100 then

3)column 2 - result !

[rong]

Hi Gautham,

You need to isolate the subtract first, so add bracket as shown below in your expression for variance %

((column(2)-column(1))/column(1))*100

[gauthamchilled]

not sure in my data model...total alone is not correct when i use expression total...cant share the data

any one knows what could be the reason?

[MK_QSL]

Use this expression for last Column...

((column(2)-column(1))/column(1))*100

or

Num((sum(Proforma)/sum(Existing))-1,'#0.00%')

[gauthamchilled]

[MK_QSL]

check attached file..