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....
The ISNULL function in JET (used for Access & Excel) simply returns true or false. You cannot use more than one argument with ISNULL here...
Try the following instead