topic Re: error in sum total in QlikView

error in sum total

Thu, 19 Feb 2015 21:53:40 GMT

hi,

somehow my sum(total is not working in the attached file.

kindly help.

Anonymous — Thu, 19 Feb 2015 22:08:48 GMT

Change your second Expression to

=(Sum([Time to complete])/Sum(Total [Time to complete]))*sum(Allocation)

you Need to Change to sum(allocation)

please check if the result is correct. if not, write what you want to achieve

hic — Fri, 20 Feb 2015 07:35:27 GMT

It depends on what you want to calculate... Rudolf's suggestion is one possible way. Other possibilities are

(Sum([Time to complete])/Sum(Total [Time to complete]))*Avg(Allocation)

Sum([Time to complete]*Allocation)/Sum(Total [Time to complete])

The bottom line is that you cannot have a "naked" field reference in an expression. You need to move it into an aggregation function.