I was wondering if you could help me with a quick syntax question. The report I am working on needs to be filtered by these specific work centers, but I need the Jobs to show the [Job Sched Start Date: Sum: Job Route Sched Setup Hours] from the Setup operation for the below formula.
([Job Sched Start Date: Sum: Job Qty Released] / [Job Sched Start Date: Sum: Job Route Sched Pieces/Mch Hr]) + [Job Sched Start Date: Sum: Job Route Sched Setup Hours]
This is what I have attempted to do but can't seem to get it right.
LOOKUPROW(0,0,[Jobs.Job],SELECT [Job Sched Start Date: Sum: Job Route Sched Setup Hours],[Work Centers.Work Center] FROM [ALL] WHERE [Work Centers.Work Center]='LV3-S')
I need the work center LV3 to say 1.50 instead of 0 and so I am trying to do a lookupRow but I am returning the result 64495.2 instead of 1.50.
