1 Reply Latest reply on Sep 17, 2013 9:17 PM by Alex Kerin

    IFNULL statement points to a column value

    Steven Soillis

      Is it possible to return the value in a column when the value is null?


      Example if in Row NORTH since Total Sales is NULL then show the value in Regional Sales.


      NORTH NULL1750
      EAST 1000NULL
      WEST 5000025000


      The only examples I see is to show an expression such as if Total Sales is null then "No Sales"