Try: Round({LaborDtl.LaborHrs}*4)/4
Depending on your desired rounding up/down of extra minutes, Floor or
Ceiling might be more appropriate than Round. And you might want to sum
before rounding, unlike my example above.
Brian.
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jen
Sent: Friday, June 17, 2011 12:14 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Rounding Indirect time to the nearest 15 minutes
Does anyone have a Crystal formula that rounds the laborhours field to
the nearest 1/4 hour ==> .25, .50, .75, and next whole hour? I'd also be
willing to take a business logic change in Epicor that changes the labor
dtl record upon end activity...however, I suspect this will be more
difficult. I just need a report that's down and dirty for a particular
employee.
[Non-text portions of this message have been removed]
Depending on your desired rounding up/down of extra minutes, Floor or
Ceiling might be more appropriate than Round. And you might want to sum
before rounding, unlike my example above.
Brian.
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jen
Sent: Friday, June 17, 2011 12:14 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Rounding Indirect time to the nearest 15 minutes
Does anyone have a Crystal formula that rounds the laborhours field to
the nearest 1/4 hour ==> .25, .50, .75, and next whole hour? I'd also be
willing to take a business logic change in Epicor that changes the labor
dtl record upon end activity...however, I suspect this will be more
difficult. I just need a report that's down and dirty for a particular
employee.
[Non-text portions of this message have been removed]