Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Formula Help - Omit summary tasks from formula?

2 replies [Last post]
Wed, 2016-09-28 12:36
Sam McCrae
User offline. Last seen 7 years 28 weeks ago. Offline
Joined: 31 Aug 2016
Posts: 5
Groups: None

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.

Top

Replies

Tue, 2016-11-15 17:43
#1
Chris Lothian
User offline. Last seen 38 weeks 5 days ago. Offline
Joined: 18 May 2007
Posts: 34
Groups: Civil Engineering, TILOS
This might work.... If(SubType=SummaryType, "", switch(PlannedPercentComplete(CB,na)>PercentComplete,high,PlannedPercentComplete(CB,na)<=PercentComplete,low))
Top
Wed, 2016-09-28 14:06
#2
Mike Testro
User offline. Last seen 4 weeks 2 days ago. Offline
Joined: 14 Dec 2005
Posts: 4418
Groups: Building Information Modelling, Content Moderators, GPCCAR Editors

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

Top