caculation in report

[Mike Hughes]

I have a report with a field named TOTAL_CASES and a field named SumOfPAYING_CASES.

I want to add caculated field to the report which will give me the percentage of cases which are paying.

I thought it would be something like this, but this did not caculate correctly or didn't work at all.

=Sum ([SumOfPAYING_CASES])/([TOTAL_CASES])

I'm doing something wrong

Here is an example of what I'm getting as a result:

SumOfPAYING_CASES = 2362
TOTAL_CASES = 4624

This is what I get for a percent of paying cases 36%
My caculator shows it should be around 51%

Can anyone help me please

Thanks

 

[martinw]

Make sure the fields are set up as numerical and not text. Then if the field names are correct, it shoud give you a decimal number providing the field that houses the result is numerical with a decimal place of what ever you require 2,3,or 4 etc.