5 Replies Latest reply on May 23, 2020 2:06 PM by Jonathan Drummey

    Multiple IF and ISNULL

    Nishesh Ved

      Hi Community

       

      I am trying to sort a formula but just unable to figure out the correct structure

       

      I have three fields and i have created a calculated field to test if any of this has a value it should populate the calculated field. I am also testing if there is a null in any of these fields, if they are null it can check for other fields to find the value.

       

      Can someone please help - i have got the below

       

       

       

      IF (ISNULL([Costelementfor supplier]))

      or (isnull([Vendor Sum Name]))

      OR (ISNULL([Summary Name]))

      THEN

        [Summary Name] ELSE[Vendor Sum Name]

       

        END