18 Replies Latest reply: Sep 22, 2015 12:55 PM by Mark Graham RSS

    Nested If Statement

    Mark Graham

      Hi, I was trying to do a nested if  statement,

      Where if the filed "Name"is null and "Filter count" >1 then i wanna display the field "Dept"

      Else "Name"

       

      Can some pls look into this.

       

      If(Len(Trim(Name))=0,Dept, If([Filter Count] > 1,  Dept, [Name])) as [New Column],