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

       

      IF

      ISNULL([Class (Hardware)])

      THEN

      [Class (Database)]

      ELSE

      [Class (Hardware)]

      END

       

      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