Sum of Column and then divide


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



muhammad.rehman's picture
Joined: Jun 30 2014 - 4:18am
Last seen: 5 years 7 months ago

Can you please elaborate the issue.

rajesh.sirsikar - 6 years 2 months ago

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

djohnson53 - 6 years 3 weeks ago

0 Answers:

No answers yet