Wrong total in total line

[#1]

in my attachment you can see that the total is not correct

i like to use the if statement because in my real file the formula is very complex.

How are totals calculated in QV? why is the sum not correct?

is use this formula

if

(User_id=1,0,Sum(number))

is it also possible to change the sum in avg??

[#2]

It is hard to tell without a sample application to work with, but it is usually aggregation functions nested inside the IF that cause the problem. Can you take the sums off of CODA_ASSETBOOK_COST and CODA_ASSETBOOK_RESIDVALUEASSET and place a sum around the entire IF statement at the top level?

[#3]

You are my STAR! *

that's the solution

thank you very much, and thanx for this great community!!

[#4]

One more question

in my picture you see 2 pivot tables, is it possible to have the total line like in the second table, or is it only possible to have a sum in the total line??