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 :-
SUM(IF TRIM([Defect Type]) = '' THEN [Input Qty] END)
SUM(IF ISNULL([Defect Type]) THEN [Input Qty] END)
SUM(IF [Defect Type] = Null THEN [Input Qty] END)
Is there I'm missing out?
Thank you.
本文标签:
版权声明:本文标题:tableau desktop - Rows Calculation using SUM & IF function for EmptyNULL value on specific field is not calculated - Sta 内容由网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:http://www.betaflare.com/web/1744721267a2621709.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
发表评论