10 Replies Latest reply: May 2, 2017 8:01 AM by Mark Ritter RSS

    Replace Null value with Placeholder Text

    Justin Dallas

      Hello Everyone,

       

      I have a data model where I have "Workers" who have records in a "PayDetail" table. This "PayDetail" table also has a linking to an "Order" table.  HOWEVER, not every PayDetail has an associated Order (i.e you pay someone for undergoing HR training or recertification). 

       

      I'm representing this data in a Pivot table, and because of the structure, I end up with pay columns that have a "-" as their Order Number.

       

      EmptyOrderNumber.png

       

      Is there a way I can say "if the OrderNumber is null then show Blah"?  I've tried the following statement, but it didn't change anything:

       

      IF(ISNULL([Order Number]),'OTHER',[Order Number])
      

       

       

      Any help is greatly appreciated.