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.