EXPRESSION PROBLEM

[adiarnon]

hi,

I HAVE TWO TABLES:

Resource ID	Resource Name
1	A
2	B
3	C

DATE	Resource ID	AVAILEBLE HOURS	WORK HOURS
1.1.14	1	9	10
1.1.14	2	9	8
1.1.14	3	9	12
2.1.14	1	9	9
2.1.14	2	9	8

I WANT TO SHOW A NUMBER -

HOW MANY RESURCE HAVE MORE WORK HOURS THAN AVAILEBLE HOURS

IN MY CASE - 2 :

1 - AVAILEBLE HOURS:18 ,WORK HOURS:19

3 - AVAILEBLE HOURS:9 ,WORK HOURS:12

WHAT EXPRESSION SHOULD I WRITE?

TNX.

[preminqlik]

count({<ResourceID={'=[Working Hours]>[Available Hours]'}>}ResourceID)

for distinct

count(distinct {<ResourceID={'=[Working Hours]>[Available Hours]'}>}ResourceID)

[tresesco]

In a text box, try like: =Count({<[Resource ID]={"=Sum([AVAILABLE HOURS])<Sum([WORK HOUR]"}>} Distinct [Resource ID])

[Gysbert_Wassenaar]

=count({<[Resource ID]={'=sum([AVAILEBLE HOURS])<sum([WORK HOURS])'}>}DISTINCT [Resource ID])

[tresesco]

Prem, you missed the aggregation. Isn't it?

[swuehl]

Try in a text box:

=count({<[Resource ID] = {"=sum([WORK HOURS]) > sum([AVAILEBLE HOURS])"}>} distinct [Resource ID])

[#7]

Use this,

Count(Distinct Aggr(sum([WORK HOURS])>sum([AVAILABLE HOURS],[Resource ID]))

Regards,

Prabhu

[adiarnon]

hi,

TNX for all the answars.

iits working!!!!!!!!!!!!

BUT,

i have a Another challenge:

i want that when i click on that text box it will choose all the resource that HAVE MORE WORK HOURS THAN AVAILEBLE HOURS

how can i do that????

[tresesco]

adi arnon wrote:

....

i want that when i click on that text box it will choose all ....

You mean select ? You have to use a trigger for that. Try to share your a sample qvw.

[adiarnon]

Unfortunately i cant share.

i mean that it will select in the field 'Resource ID' all of those who HAVE MORE WORK HOURS THAN AVAILEBLE HOURS

hope its more clear