This is a migrated thread and some comments may be shown as answers.

Simple percentage does not calculate

1 Answer 254 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Jon_BCV
Top achievements
Rank 1
Jon_BCV asked on 28 Feb 2013, 08:23 PM
Hi..
I have the following expression in a field in a group footer

=sum(fields.DysfuncCount)/Sum(fields.ActiveCount)

But it always returns  0

DysFuncCount is 30     ActiveCount is 139

What am I doing wrong?

thx

1 Answer, 1 is accepted

Sort by
0
Jon_BCV
Top achievements
Rank 1
answered on 28 Feb 2013, 08:39 PM
Guess I have to cast it.....................
=CDbl(sum(fields.DysfuncCount))/CDbl(Sum(fields.ActiveCount))
Tags
General Discussions
Asked by
Jon_BCV
Top achievements
Rank 1
Answers by
Jon_BCV
Top achievements
Rank 1
Share this question
or