Trying to create a GI that would show the following:
| Prod Order ID | Operation A | Operation B | Operation C | Operation D | Operation E |
| AM000034 | 04:11 | 02:09 | 12:00 | 00:45 | 00:45 |
| AM000035 | 05:26 | 03:35 | 19:05 | 01:55 | 02:05 |
How do I structure the GI so the operation ID are the column headers and the operations run time are the values in the table?
Thanks!
+1You would need to create a calculation for each operation using an IIF function.
For example, IIF([AMProdOper.OperationCD[=’0110’,[AMProdOper.RunUnitTime],0)
You would need to create a calculation for each operation using an IIF function.
For example, IIF([AMProdOper.OperationCD[=’0110’,[AMProdOper.RunUnitTime],0)
Thanks - that’s exactly what I thought but can’t get the AMProdOper.RunUnitTime toshow correctly when using the formula. See formula & output below.
Output shows 431 when it should show 07:11.
No change when I add Schema Field - AMProdOper.RunUnitTime. Is there something I need to add before the formula to ensure it stays in that same format?
+1It’s displaying the result in seconds.
Are you putting [AMProdOper.RunUnitTime] in the schema field?
It’s displaying the result in seconds.
Are you putting [AMProdOper.RunUnitTime] in the schema field?
Yes but with [AMProdOper.RunUnitTime] in schema field it displays as 43:1
+1How about =CDec([AMProdOper.RunUnitTime])/60 ?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
