admin管理员组

文章数量:1391968

I have 2 table that all filters are link to each other except for 1 field called "Defect Type" that do not exist in first table.

.jpg

For second line graph (Input Qty) shown 2 line that is "Defect Type" (TapLWBent & NULL). This should not happen because "Input Qty" is in the first table that "Defect Type" does not exist. And I try to do SUM & IF function on third line graph to pull data with NULL / Empty value of "Input Qty", however the result is not shown. I've tried multiple rows calculation for third line graph :-

  1. SUM(IF TRIM([Defect Type]) = '' THEN [Input Qty] END)
  2. SUM(IF ISNULL([Defect Type]) THEN [Input Qty] END)
  3. SUM(IF [Defect Type] = Null THEN [Input Qty] END)

Is there I'm missing out?

Thank you.

本文标签: