Skip to Content
0
Former Member
Jul 27, 2016 at 07:13 PM

Simple division field on report does not work

24 Views

Hi All,

I have a report that has a field for Sum of Time_Recorded in the Group Footer and Maximum of Productive Hours in the same group footer.

The values for these columns for one of the users is 7.5 hours and 7.5 hours respectively. Hence I have created a formula that uses a simple division of these fields as follows:

Sum ({@TIME_RECORDED})/ToNumber(Maximum ({PRODUCTIVITY_LOG.PRODUCTIVE_HOURS}, {USERS.USER_NAME}))

However instead of showing the answer as 1, the report displays 21.81. Any idea on what maybe going wrong?

Thanks