Caluation and Set Analysis

[#1]

I have a set of work orders that are broken down into the following categories:

Age of the Work Orders by Trades

Trade      0-29     30-59     60-89     90+

    A

    B

    C

The work orders can have various status but what I would like is a count of work orders in each of the 4 groups based on total new, and working.  The other item is I only want work days which I believe is use the networkdays command.

Any help would be grateful.

Thanks,

[chiru_thota]

I  assuming your data as below.If yes you can write

sum({<Status={'New','Working'}>}0-29) + sum({<Status={'New','Working'}>}30-59) +

sum({<Status={'New','Working'}>}30-59) + sum({<Status={'New','Working'}>}90+)

Trade	Status	0-29	30-59	60-89	90+
A	New	1
B	Working		1
C	New			1
D	Working				1
E

[ashwanin]

Can you post a sample?

Bz what i believe, you have to do aging of workorders and then have to segregate the same as new and working