7 Replies Latest reply on Feb 25, 2016 7:54 AM by Łukasz Majewski

    displaying 0 in nulls fields doesn't work with calculated field (calulated field have a attribute inside)

    manuel bermudez

      Hi,

       

      I can display 0 in my woorksheet in tableau with this calulated field (0's Avg.): ZN(LOOKUP([Avg], 0))

       

      tableau 0 works.jpg

       

      The problem appears when i put in rows this calulated field, the name of calulated field is Local and is this:

      CASE ATTR([copy])

      When "Data" THEN ATTR([Local])

      WHEN "Total Sub-Category" THEN

      "Stock in hall"

      ELSE

      IF index()=window_max(index()) THEN

      "Stock in total"

      END

      END

       

      tableau 0 doesnt work.jpg

       

      What happens? Where is the problem? Why when i put a this calculated field in rows dimension, the 0 dissapears?

       

      Thanks a lot!

       

      Sincerely,

       

      Manel