How to hide allocations

[posywang]

Hi,

I am trying to hide project allocations if resource is fully allocated to projects as 1 FTE. However, I am not able to hide allocations at a lower level, project level in this case. Is there a way to hide highlighted numbers when Show Variance button is clicked? Thanks!

[sunny_talwar]

The complete column should go away?

[posywang]

Yes in this case since everyone is fully allocated in January. Of course, if someone is allocated say 0.8 in total in January, that allocation should be kept.

[sunny_talwar · Accepted solution]

Try this expression

=If(Sum(TOTAL <Resource, Mth> FTE)=1,0,Sum(FTE))

[posywang]

Thanks! Works like a charm!