Expand my Community achievements bar.

How to display hours as days on an hour report?

Avatar

Level 10
I have an Hours matrix report. I would like to display the values as Days instead of hours. E.g. If the item is 8 hours, this would show as 1 day. 12 hours would show as 1.5 days, etc. According to the advanced reporting manual, it looks like it may be possible. I have tried changing the displayformat to be "minutesAsDaysString" but it treats the hours as if they are minutes when converting them to days, so the result is wrong. I can’t see how to get it to convert Hours to Days. I also can’t (obviously) create a custom field on Hours objects so I can’t convert hours to Days that way. Any help would be greatly appreciated! Regards, David
Topics

Topics help categorize Community content and increase your ability to discover relevant content.

5 Replies

Avatar

Level 10
Hi David, Have you tried changing the valuefield=hours to valueexpression=DIV({hours},8)?

Avatar

Level 10
Thanks Anthony. That does the trick in terms of showing the line-level records as day values. I've then played around with a few options to try to get the aggregators to also show the total in days but I'm not having much luck yet. If I use the same concept to make aggregator.valueexpression=DIV({hours},8) the report won't display properly. Reverting back a step, what I currently have is the following. If you have any further suggestions it would be appreciated. aggregator.displayformat=doubleAsDouble aggregator.function=SUM aggregator.namekey=hours aggregator.valuefield=hours aggregator.valueformat=doubleAsDouble displayname= linkedname=direct namekey=hours querysort=hours textmode=true valueexpression=DIV({hours},8) valueformat=doubleAsDouble

Avatar

Level 10
So I was playing around... It seems if you have a custom field/aggregator, it does not work show the value in the summary tab, matrix reporting, or in a chart. I went to some other reports that are different object tabs and getting the same thing. So weird. I would have thought if it can display in the details tab, it could display in a matrix or chart. If you have any remote consulting hours left, you might want to schedule some time with Jason Webre. He is great on unique reporting needs. :)

Avatar

Level 10
OK - thanks for looking into it further, Anthony. I've booked in some time with our local consulting team in Australia. Will see how we go! Cheers

Avatar

Level 1
Hello! I have the same question. Were you able to aggregate the data into days ? Thank you! Catherine Simonson