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....