Skip to Content
Former Member
Apr 24, 2007 at 06:25 AM

Calculating the values in Query Designer...


Hi Experts,

I need to calculate the value of Total PM job Completion Index, where the formulae for that is

Actual No Of Preventive Jobs Completed(A) / Total No of Preventive Jobs(B)

Where as,

A = Count of Work Orders with Order type = PM01 and System Status = TECO.

and B = Count of the no of work orders, with order type = PM01.

I have Work Order and Status as charecteristics, can anyone of you please help me out with the solution. i.e, how to calculate the value of A & B and the value of PM Job completion Index...

Advance Thanks,