1 Reply Latest reply on Nov 13, 2018 11:37 PM by suresh.gooty

    Connect two tables with empty category

    Bert Dong

      Dear Forum,


      I am learning the almighty Tableau and facing this situation.


      I need to connect two table together. Which I have attached to the thread.


      How to show the red squared place as 0 instead of blank.


      Please help me learn, thank you all!



      Screen Shot 2018-11-14 at 1.46.29 PM.png

        • 1. Re: Connect two tables with empty category

          after creating all the final dashboard... create calculated formula with each field by using function ZN which will convert null to 0... ZN([Wine],0) good luck... create calculated fields for all the fields where square brackets are there..... good luck... mark as answered or helpful if it works... thanks in advance.....