4 Replies Latest reply on Jul 27, 2018 7:10 AM by James Needham

    Multi if ISNULL statements

    James Needham

      I have 3 data sources (Hardware, Database, Network). Each has a class field, which I want to return the value of.


      Currently I am using the below calculation



      ISNULL([Class (Hardware)])


      [Class (Database)]


      [Class (Hardware)]



      This gives me the result of Hardware, and if hardware is null populates the Database information. I now want to introduce Network, but the variations I have tried haven't worked. Any Suggestions