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 5 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

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts