N
NelsonG
I have created custom fields as status indicators. Three of these are
Enterprise Flag stoplight indicators, returning “yes†or “Noâ€. These are
working correctly, with a Green, Yellow or Red indicator.
I have also created two fields to use as counters for the stoplight
flags. Enterprise Text and Enterprise Number, as described below:
Enterprise Text: IIf([Enterprise Flag2] Or [Enterprise Flag3]=Yes,1,0) ;
with “Use formula†for the calculation for Task.
Enterprise Number: IIf([Enterprise Text3]=1,1,0) ; with “Rollup†and “Sumâ€
for the calculation for Task.
This works fine at the Task level custom fields, but when I try to
represent these same formulas at a Project level custom fields, so I can
display the result on the Project Center on PWA, it doesn’t work.
I’m importing the formulas from Enterprise Text to Enterprise Project
Text and from Enterprise Number to Enterprise Project Number, but I only get
zeros (0), on all tasks and the rollup Project Summary Task for these.
Can someone help me display what I have at the task summary level to the
project level on PWA?
Thanks, NelsonG
Enterprise Flag stoplight indicators, returning “yes†or “Noâ€. These are
working correctly, with a Green, Yellow or Red indicator.
I have also created two fields to use as counters for the stoplight
flags. Enterprise Text and Enterprise Number, as described below:
Enterprise Text: IIf([Enterprise Flag2] Or [Enterprise Flag3]=Yes,1,0) ;
with “Use formula†for the calculation for Task.
Enterprise Number: IIf([Enterprise Text3]=1,1,0) ; with “Rollup†and “Sumâ€
for the calculation for Task.
This works fine at the Task level custom fields, but when I try to
represent these same formulas at a Project level custom fields, so I can
display the result on the Project Center on PWA, it doesn’t work.
I’m importing the formulas from Enterprise Text to Enterprise Project
Text and from Enterprise Number to Enterprise Project Number, but I only get
zeros (0), on all tasks and the rollup Project Summary Task for these.
Can someone help me display what I have at the task summary level to the
project level on PWA?
Thanks, NelsonG