Published on Planning Planet (http://www.planningplanet.com)

Home > Discussion Forum > Formula Help - Omit summary tasks from formula?

Formula Help - Omit summary tasks from formula?

By Sam McCrae
Created 28 Sep 2016 - 12:36
Submitted by Sam McCrae on Wed, 2016-09-28 12:36

Hello,

 

The below formula will give a red cross at a task which have an actual%complete less than the planned%complete, and a tick in other cases.

 

switch(PlannedPercentComplete(CB,na)>PercentComplete,high,PlannedPercentComplete(CB,na)<=PercentComplete,low)

 

Has anyone any idea what I could add to this formula to stop summary tasks from recieving this cross/tick?

 

Thanks.

By logging in, inputting data or deciding to view any further of our pages you agree to be bound by our Forum Rules, our T&C's and also our Privacy Policy
© Planning Planet 2000-2024. Run by Project Controllers for Project Controllers.
Source URL: http://www.planningplanet.com/forums/asta-powerproject/595390/formula-help-omit-summary-tasks-formula

Links:
[1] http://www.planningplanet.com/forums/asta-powerproject