Skip to content
ProjectControls.com
Asta Powerproject

Formula Help - Omit summary tasks from formula?

In the Open Standard
Sam McCraeMember for 10 years 1 month
Created
2
4
0

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.

Save Follow Follow forum Report
Reply New topic

2 replies

Oldest first
  1. 0
    Mike Testro ·
    #1

    Hi SamThe fact that the tick

    Hi Sam

    The fact that the tick appears on summary bars is highly beneficial in that it allows you drill down through the summaries to find the problem task.

    It is about time that Asta made the formula's more simple to administer by using a series of choices in drop down format.

    Best regards

    Mike Testro

    Report
  2. 0
    Chris Lothian ·
    #2

    This might

    This might work....
     
    If(SubType=SummaryType, "", switch(
    PlannedPercentComplete(CB,na)>PercentComplete,high,PlannedPercentComplete(CB,na)<=PercentComplete,low))
    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?