This content has been marked as final. Show 3 replies
My script has this syntax:
COST_GAS, COST_DEPR, COST_MAIN, COST_HWY, COST_ADMIN, COST_SALARY,
(COST_GAS + COST_DEPR + COST_MAIN + COST_HWY + COST_ADMIN + COST_SALARY) As [TOTAL_COST]
In qlikview pivot chart, i have an expression- SUM(TOTAL_COST)
The result of it is wrong!
If I create expression summing all costs like this- SUM(COST_GAS) + SUM(COST_DEPR) + ..... and so on.
The result is correct.
Why is the script adding won't work.