Planned Duration Field on Project Task form

Andrew Bettcher
Kilo Sage

Hello,

Firstly, MERRY CHRISTMAS to everyone.

There are two duration fields on the OOTB project form called work_duration and work_effort.

find_real_file.png

We haven't chnaged anything and so, provided the preference is ticked, the actual effort sums from approved time cards submitted against the project and then a calculation is done to give me remaining hours (using the original effort duration field.

The problem is that, as above, the actual duration displays Days, Hours, Mins and Secs but the actual effort only shows Hours, Mins and Secs.

I've compared the dictionary entries, tried a calculated value, triued a script that hides the hours mins and secs and tried a default value of 00 00:00:00 which I thought might set the format. Nothing works.

I can get a calculated value to wpork easily but it merely fits the return into the same box as best it can OR shows a standard grey field with no divisions. That would be OK except that there is no value in it.

If I replace the field with a different field type will I be able to still get the calculatuions to work and where would I look to make sure taht I'd changed everything or, is there any other way people can think of how to get it to show days?

 

To add to the mystery, the Planned Effort tables looks like this:

find_real_file.png

But is configured the same way.

 

Any ideas?

 

2 REPLIES 2

Andrew Bettcher
Kilo Sage

Also, why is the field decoration for the roll_up calc on the next line when, for all other fields that has the same attribute, it's in line:

 

find_real_file.png

Andrew Bettcher
Kilo Sage

Solved with the following Before Update Business Rule:

 

var time = (current.remaining_effort.dateNumericValue());
current.u_remaining_effort_days.setDisplayValue(time/(60*60*7.5*1000));

 

Still got the decorations in the wrong place and need to work out how to restrict the number of days returned to 1 or 2 decimal places.