GetWorkingTimeForGivenPeriod (user as ObjectIdentifier, dateTime1 as DateTime, dateTime2 as DateTime) as Duration
|Description:||Returns the Working Time for a user for a specific period of time. Where the "user" argument can be a specific user or a reference to user field. "dateTime1" and "dateTime2" arguments are used to determine the period of interest.|
|Supported Context:||FormulaField And BusinessRules|
|user as ObjectIdentifier(User)||Represents a reference to a user object or a field that returns a user object|
|dateTime1 as DateTime||Represents a reference to a from date or field that returns a date value|
|dateTime2 as DateTime||Represents a reference to a to date or field that returns a date value|
|Returned value as Duration||Returns a duration value equal to the total number of working hours for the user specified in the "user" parameter for the date range specified in the "dateTime1" and "dateTime2" parameters|
Calculate the Bill to Burn KPI on the user entity.
Within a workflow rule, select the "Update Field" action and select the custom field Bill to Burn KPI (needs to be created by your organization first).
$C_BilltoBurn/(GetWorkingTimeForGivenPeriod(CurrentUser(), 06/05/2011, 07/15/2011)/Hours(1))