4 Replies Latest reply on Jul 6, 2016 1:34 AM by Mark Fraser

    Grouping 'null' and '#N/A' values from same datasource

    katie.weander

      For a certain field, some of the values are null and some show #N/A. We'd like to group both together to be able to quantify the missing volume. I tried wrapping the null in an IFNULL([field], "Missing") and doing an ELSEIF '#N/A' then 'Missing' ELSE [field] but no luck.

       

      Any ideas??

       

      Thanks!!