Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want the total mean =15.68 into the 'Testing Time' table.
where the total mean It will change depending on the selection of 'CodePart' or 'Part'.
I currently have this code in the Testing Avereage table:
Sum( Aggr((TestingTime*TotalOut),ID,WSGroup,,WorkOrderNo,Type,TransactionDate))/Sum(Aggr(TotalOutRetest,WorkOrderNo,ID))
If I understand your issue correctly then you can solve it using TOTAL, like this:
Sum(Total Aggr((TestingTime*TotalOut),ID,WSGroup,,WorkOrderNo,Type,TransactionDate))/Sum(Total Aggr(TotalOutRetest,WorkOrderNo,ID))