Post

3 followers Follow
0
Avatar

How can I calculate Actual Effort by rate/hour?

How can I multiple the actual effort by a rate per hour? I can make the field but Im getting an error when multiplying a duration field.

Kenny Paltzat Answered

Please sign in to leave a comment.

2 comments

0
Avatar

Hi Kenny,

Any reason you are not using the standard out of the box Cost fields?

Yossi Truzman 0 votes
Comment actions Permalink
0
Avatar

Kenny,

Actual Effort is a duration and rate/hour is a numeric value. You need to make the duration field into a numeric value using the function ToNumber($ActualEffort)...

ToNumber($ActualEffort)*<RegularRateField>

Boris Krutiy 0 votes
Comment actions Permalink