It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,860

question asked: Jul 30 '10, 8:50 a.m.
question was seen: 5,608 times
last updated: Jul 30 '10, 8:50 a.m.

Related questions

RTC Reporting - conversation of integer values

0
Katrin Heymann (198●2●45●63) | asked Jul 30 '10, 8:50 a.m.
Hi,

I want create a report with WIs grouped by an enumeration field "Application" and Time Spent.

User added e.g. "22 hours" in the Time_Spent field. In the report of the field I see "79200". Only divide it with 3600 will not give the correct sum.

Does anyone know how to calculate the correct value ?

Katrin Heymann

3 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Katrin Heymann (198●2●45●63) | answered Aug 03 '10, 3:18 a.m.
Additional information:

Following entries in the WI group:

ESTIMATE
5 hours
Unassigned
Unassigned
5 hours

The sum of 10 hours were shown as 35999 in the report. Only divide with 3600 will not show 10.
0
permanent link
Ralph Schoon (63.4k●3●36●46) | answered Aug 03 '10, 7:26 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
For whatever the result seems to be missing a second. Maybe calculation precision? However maybe you can round the result?

Ralph
Additional information:

Following entries in the WI group:

ESTIMATE
5 hours
Unassigned
Unassigned
5 hours

The sum of 10 hours were shown as 35999 in the report. Only divide with 3600 will not show 10.
0
permanent link
Katrin Heymann (198●2●45●63) | answered Aug 03 '10, 9:12 a.m.
BirtMath.round works to solve my problem.

I only want to know if there's an official way to realize it.

Thanks for your answer.

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.