error in sum total

[#1]

hi,

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

kindly help.

[Anonymous · Accepted solution]

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]

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.

See also It’s all Aggregations

HIC