Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Sxbbb
Creator III
Creator III

I want the total mean =15.68 into the 'Testing Time' table.

Sxbbb_0-1679020019361.png

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))

 

 

1 Reply
Vegar
MVP
MVP

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))