Customized "Work" field

[Thomas]

I need a customized field that calculates the following
IIf([Remaining Work]=0;[Baseline Work];0
That is: I need the field 0 as long as Remaining Work is not 0. When Remaing Work is 0 i want the field to be equal to Baseline Work.
I tried this: Entered the above formula in a custom "duration" field - but the field stays 0 no matter what the value of Remaining Work is. Any clue?

 

[Gérard Ducouret]

Hello Thomas,

No problem : your formula works fine on my PC.
Haven't you forgot to save the baseline ?

Gérard Ducouret

I need a customized field that calculates the following:
IIf([Remaining Work]=0;[Baseline Work];0)
That is: I need the field 0 as long as Remaining Work is not 0. When

Remaing Work is 0 i want the field to be equal to Baseline Work.

I tried this: Entered the above formula in a custom "duration" field - but

the field stays 0 no matter what the value of Remaining Work is. Any clue?

 

[Thomas]

I closed the project (master) and created a new one (not master; single) and did the same to some tasks there. Now the formula works - for a while.. After playing a little with different values the formula seems to stop working for some tasks; one of the tasks still works as it should while the other one leaves the custom field 0 (worked before). In addition the cells starts blinking and the timeglass (for the mouse) is coming and going... For a while it seemed to matter if I changed the Remaining Work for the resource instead of directly on the task, and I thought it might have to do with defining the custom field as "Task" or "Resource" type, but now that is not consistent with my errors either. Would appreciate if you tell me whether you find out something - I'll keep searching for a solution.