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
