Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.