Total Line

[#1]

In my Qlik project I do hae 4 collums :  vPUNIT_CV_I vPUNIT_CV_II VOL_CV_I and  the ohter is a formula:  (vPUNIT_CV_I - vPUNIT_CV_II)*vVOL_CV_I) - this is calculated for inflation.

I need in my tottal line the result of s single SUM of this formula but the QLIK calculated again the formula.

There is someone that could help me?

Regards ! !

[avinashelite]

could you elaborate with an example ?? or sample app

[Anil_Babu_Samineni]

I am not sure, I understand fully. Would you describe more

Sum(vPUNIT_CV_I)  - Sum(vPUNIT_CV_II) * Sum(vVOL_CV_I)

Or

(Sum($(vPUNIT_CV_I))  - Sum($(vPUNIT_CV_II))) * Sum($(vVOL_CV_I))

[#4]

Avinash,

please have a look at the attached file.

[#5]

!

[Anil_Babu_Samineni]

If condition seems only you need to get values when 0. So this case if value of Scenary I or II is o then how you would get value devide 0 -- It should return Infinity for this case

[#7]

I need to have the formula when the both fields where different of 0.

ANd I need to have a SUM of the values that is the result of the formula:

the click includes 357 in the total line

I nedd a sum of -75 + 0 + 23 -39 + 36 + 20 + 92 + 2 -17 + 66 -86 = total is 22

[Anil_Babu_Samineni]

Would you provide application, Please? For me it's difficult without seeing data

[#9]

Saminedi,

How can I include my qvw here?

[#10]

Do you have an e-mail address ?