1 Reply Latest reply on Jun 17, 2013 8:39 AM by Robin Kennedy

    Cant quite get a  SUM ISNULL from a Custom SQL query to work like a ZN in Tableau

    Craig Dewar

      I've got some monthly environmental metrics that I have available to me in XLSX - many of which are NULL

       

      I sum a bunch of monthly Fuel metrics in Tableau successfully using the ZN()+ZN().... to turn the NULLs in to zero.

       

      I need to do a similar sum at a YEAR level with a GROUP BY back in my custom SQL - so that I can do some further pre-agg calcs back at the monthly level.

       

      However, after much googling  I am struggling to get it work.

       

      See the screen shots attached for frther info.

       

      Hope you can help....

       

      cheers

       

      craig