C
CMTH
I have a report that has a a Job Type footer and an Operator footer with
calcuations in each based off of a target number that is different for each
job type.
I have two different job types:
Job type 02 with a target of 4600
Job type 259 with a target of 2320
The calcuation for the job type footer basically takes some production
number and divides that number by the above target number for the correct job
type and this calculation works correctly.
The calcualtion for the operator footer needs to be the sum of the
production numbers and divide that number by the sum of each job type target
the operator ran.
Example 1:
Operator ran two job type 02's with a total production of 5000
My calculation would be 5000/4600
Example 2:
Operator ran two job type 259's with a total production of 5000
My calculation would be 5000/2320
Example 3:
Operator ran one job type 02 with a producaiton of 5000 and one job type 259
with a producaiotn of 5000
My calculation nees to be 10000/4600+2320
What I need to do is obtain the SUM of the target numbers for each of the
job types, but I am unclear on how to do this.
I have tried the following IIf statement, but the result is always a -1 or
NULL:
=IIf([Job Type]=2,"4600" Or IIf([Job Type]=259,"2320" Or IIf([Job
Type]=59,"300",Sum([Job Type]))))
Any help will be greatly appreciated!
calcuations in each based off of a target number that is different for each
job type.
I have two different job types:
Job type 02 with a target of 4600
Job type 259 with a target of 2320
The calcuation for the job type footer basically takes some production
number and divides that number by the above target number for the correct job
type and this calculation works correctly.
The calcualtion for the operator footer needs to be the sum of the
production numbers and divide that number by the sum of each job type target
the operator ran.
Example 1:
Operator ran two job type 02's with a total production of 5000
My calculation would be 5000/4600
Example 2:
Operator ran two job type 259's with a total production of 5000
My calculation would be 5000/2320
Example 3:
Operator ran one job type 02 with a producaiton of 5000 and one job type 259
with a producaiotn of 5000
My calculation nees to be 10000/4600+2320
What I need to do is obtain the SUM of the target numbers for each of the
job types, but I am unclear on how to do this.
I have tried the following IIf statement, but the result is always a -1 or
NULL:
=IIf([Job Type]=2,"4600" Or IIf([Job Type]=259,"2320" Or IIf([Job
Type]=59,"300",Sum([Job Type]))))
Any help will be greatly appreciated!