strucked with set analysis

[#1]

Hi all,

strucked with set analysis,

table is like

Resource   month    exression(allocation _  project    (allocation in hours) ! ! ! ! !

kishore         jan           1                             project1

raj                jan           0.1                               project2

srikanth        jan           0.8                          project1

kishore         feb           1                             project1

raj                 feb           0.1                          project2

srikanth         feb           0.8                          project1

kishore           mar            1                          project1

raj                   mar      0.1                          project2

srikanth          mar      0.8                           project1

swetha          mar         1.2                          project3

to get these allocation i have used these expression:sum(allocation)/(176*(Count(DISTINCT month))

I want to see the count of resources where allocation <=0.8,

here i have tried count of resources where allocation<=0.8 on months

when i am trying to do these expression on years, not getting properly.

=sum((aggr(if(sum(allocation)/(176*(Count(DISTINCT month)))<0.8,count(distinct(Resource))),Resource,month)))  //(In Text Object)

for example,

Resource month allocation project

srikanth jan 0.8 project1

srikanth feb 0.8 project1

srikanth mar 0.8 project1

when  i  1) select month jan allocation(0.8)<=0.8 count=1

         2) select month feb allocation(0.8)<=0.8 count=1

          3) select month mar allocation(0.8)<=0.8 count=1

Problem:when i am selecting all 3 months resource count is (1+1+1)=3 but,(based on above mentioned expression)

my requirement is when i select all 3 months i want to get the    (0.8+0.6+0.7)/month=(0.7)(count will be ONE)

allocation(0.7)<=0.8(resource count should be one

Can you please help on these , find the attachment

Regards,

Sruthi