IF Stmnt in Expression is not working in Chart

[#1]

The IF statement in the Dimension of a Straight Table is working fine,but when i try to use the same IF statement with a minimal modification in the Expression of a Chart it returns nothing.

The IF statement used in the Dimension is given below.

=if(aggr((Sum({$<$(vUtlExceptions)>}Utilization)/Sum({$<$(vUtlExceptions)>}Available)<=.5), Name, [M1 Mgr Name], [M2 Mgr Name],[M3 Mgr Name]) , Name)

The above statement is checking if the Utilization% is less than equal to 50% then Display the name of those Employees,along with their managerial hierarchy.

Similarly i wanted to show the Count of Employees under each and every M1 Manager whose Utilization is LE (<=) 50%.

There on the Chart i have used M1 Manager in the Dimension and on the Expression tab i am trying to use the below IF statement,but it is not returning any results.

=if(aggr((Sum({$<$(vUtlExceptions)>}Utilization)/Sum({$<$(vUtlExceptions)>}Available)<=.5)),Count([Employee Id]))

I would appreciate if anybody can guide me on how to showt the count of Employees whose Utilization% id <= 50%.

Thanks in advance.

Vineet

[Gysbert_Wassenaar]

Count({<[Employee Id]={'=Sum({$<$(vUtlExceptions)>}Utilization)/Sum({$<$(vUtlExceptions)>}Available)<=.5'}>} [Employee Id])

[#3]

Hi Gysbert

Thanks for giving a shot but i am sorry to say that the statement provided by you is simply giving me the count of Employees.

Please find the attached qvw file.

[Gysbert_Wassenaar]

See attached qvw

[#5]

Yet to get the solution for this particular problem of mine.