2 Replies Latest reply on Mar 15, 2018 3:59 PM by Eric Hammond

    Add text when there is a blank in report

    Brian Fornelius

      Hi there,

       

      I have a question on trying to add text when there is a blank.

       

      I have field in a table that do an association for hotel Brand and Chain.   For those that do not roll up to a parent chain there id nothing to associate too.

       

      What I want to do is something like where there is a Code(Brand) by no chain to add "Independent"

       

      Is this something that can be done and if so how would I write the calc.   I have seen thinks for when there is a null but couldn't really find anything where there is just nothing.