Sum of Column and then divide

[muhammad.rehman]

I have a table and a calculated fields based on two columns Score and Total. My calculated field Percentage equals to Score / Total. Now when I use it in the result display is "0.00" instead of 87.5. As it is dividing first and than sum, while I need sum the column first and than divide. I tried percentage as SUM(Score) / Sum (total). But when I put it for display, it gives me dataset error. 

Thanks in advance for the help.

Score	Total
50	0
0	80
30	0
0	50
60	0
0	30

 

 

[rajesh.sirsikar]

Can you please elaborate the issue.

[djohnson53]

Yes, please post the stack dump (error messages).