Incorrect total for a percent column

[#1]

Hi,

Please look at the attached qvw where I am not getting the right value in the total of last column after I select the "show non zero budget". The total variance % remains the same regardless of whether the list box is selected or not.

I am using "Expression Total" for the % column and Sum of rows for all others.

Thanks.

[sushil353]

PFA

[#3]

-137% is not the right answer. The correct Variance % = (-100)/525 = -19%

[sujeetsingh]

Mayank actually it is due to expression sum of rows.

[phaneendra_kunc]

See if the attached helps...

Usually even though if you have enabled the SUM for the expression total...because of oyur IF statement in the ACTUAL expression total column will consider only sum(Actual) and it never evaluates the concept of where Budget is greater than zero.

Variance %    =if(Dimensionality()>0, [Variance]/[BudgetExpr] , (if(GetSelectedCount(ShowClients)>0, sum({<Budget-={0}>}Actual), sum(Actual)) - [BudgetExpr])/[BudgetExpr])