Formula Help - Omit summary tasks from formula?

S
Sam McCrae 👤 Member for 9 years 9 months

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.

C
Chris Lothian 👤 Member for 19 years
This might work....
 
If(SubType=SummaryType, "", switch(
PlannedPercentComplete(CB,na)>PercentComplete,high,PlannedPercentComplete(CB,na)<=PercentComplete,low))
M
Mike Testro 👤 Member for 20 years 6 months

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

Forum Sponsor

Top Posters

Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts
James Williams
74 posts
Haque Nawaz
10 posts
EViLL1
1 posts