I need your help ASAP
I have a report which shows the work instructions per hour (total work instructions/total hours) per picker. The report then calculates a summary at the bottom
I then need to pull the average work instructions per hour for all the pickers in another report without grouping it per picker. i.e, show value 3 in a singleton. If I use the same data item as in the detailed report it gives me a different value to that in the detail report. I suspect because it is a calculated value that is why it changes. I suppose a FOR/WHILE loop would have done the trick but my research tells me I can't use that in Cognos
I have tried every trick in my bag with no success.
Please help me as this report is due tomorrow otherwise my head is on the block.