Post

1 follower Follow
0
Avatar

Correct formula for custom field

Hi,

 

I am trying to create a custom field that is a calculated field (the sum of the actual effort logged to a project and the number of pending or approval hours logged towards a project).  I tried creating a custom field with the calculation formula being actual effort + pending but it had an error.  I do now know what I am doing wrong.  Can someone help me?

$ActualEffort+$PendingTimeTrackingEffort

Error: Formula evaluation result data type is Duration instead of expected Numeric

Thanks!

Virginia

Virginia Hoskins Answered

Please sign in to leave a comment.

4 comments
Date Votes

0
Avatar

Virginia, 

This type of Question should be asked in the Customization section of the forum to reach out to the appropriate audience. As for your issue, you cannot do what you are trying to do because you are probably running the rule on a work item and trying to pull data from a timesheet item type. 

What is your process for Time? If you are going to put time into Timesheets, be sure to specify Update Actual Effort from Timesheet'. Then you want to specify the type of Approval process you are going to have. Do you want total time to include Pending (non-Approved time)?

Please provide me a screen capture or details of the Custom Field you are trying to create specifying all settings. 

 

Sincerely, 

Boris

Boris Krutiy 0 votes
Comment actions Permalink
0
Avatar

Boris,

I want the custom field of total time to have the pending and approved time logged towards a project.  See attached for a screenshot.

 

Thanks,

Virginia

Virginia Hoskins 0 votes
Comment actions Permalink
0
Avatar

Virginia, 

I think your problem is as simple as the Field Type. You have it configured as Numeric but you are calculating time. You need to change Field Type to Duration and it should work.

 

Sincerely, 

Boris

Boris Krutiy 0 votes
Comment actions Permalink