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