jdavis501rp
IS-IT--Management
Can anyone help with a potential solution to this problem?
I need a custom field for Remaining Work which will allow me to show the total remaining work for only those resources in a particular group. I have some resources for which I include work hours but don't want their remaining hours to show in the "Remaining" column I'm going to use.
I thought I could set up a custom flag to indicate by yes/no if the resource for the task is one that I track remaining hours for, and then say something like
IIF(([TrackResc]="YES", ([Work]-[Actual Work]), 0)) in the formula for my custom 'remaining' field, but I get a number generated that is the Work column multiplied by 60. Work is in hours, and I'm speculating that MSProject is doing something under the hood that I don't know about. Any ideas?
I need a custom field for Remaining Work which will allow me to show the total remaining work for only those resources in a particular group. I have some resources for which I include work hours but don't want their remaining hours to show in the "Remaining" column I'm going to use.
I thought I could set up a custom flag to indicate by yes/no if the resource for the task is one that I track remaining hours for, and then say something like
IIF(([TrackResc]="YES", ([Work]-[Actual Work]), 0)) in the formula for my custom 'remaining' field, but I get a number generated that is the Work column multiplied by 60. Work is in hours, and I'm speculating that MSProject is doing something under the hood that I don't know about. Any ideas?