Filter Removes Summary Number

I have to think that you are getting NULL values for your rounded numbers. Such as where there are no records that match your case statements when you filter.

It would be quick to test out. Try wrapping the numeric calculations in an "IFNULL(...,0)" function to default nulls to zero. Like this:

CONCAT(
  '<div style= "Font-size:13.5px">'
  ,IFNULL(
    ROUND(
      ABS(
        AVG(
          CASE
            WHEN LOWER(`On-Time or Late`) = 'on-time' AND `New drop/live`= 'Live' 
              THEN (`Live Turn Time Data`)
            WHEN LOWER(`On-Time or Late`) = 'late' AND `New drop/live` = 'Live' 
              THEN (`Live Late Turn Time Data`)
          END
        )
      ),0
    )
  ), ' AVG "Live" Turn Time (Min) |'
  ,IFNULL(
    ROUND(
      ABS(
        AVG(
          CASE
            WHEN LOWER(`On-Time or Late`) = 'on-time' AND `New drop/live` = 'Drop' 
              THEN (`Drop Turn Time Data`)
            WHEN LOWER(`On-Time or Late`) = 'late' AND `New drop/live` = 'Drop' 
              THEN (`Drop Late Turn Time Data`)
          END
        )
      ),0
    )
  ), ' AVG "Drop" Turn Time (Min)'
)

Note: Do NOT add "ELSE 0" to your case statements without considering the effect it will have on your AVG calculation.

• ie: the average of 5,10,15,null,null is 10
  • It becomes 30 / 3 because there are only 3 numbers
• ie: the average of 5,10,15,0,0 is 6
  • It becomes 30 / 5 because zero is a real number and thus part of the average