Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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],
Hi, Mark Graham.
Exactly.
How mentioned in your first post.
Where if the filed "Name"is null and "Filter count" >1 then i wanna display the field "Dept"
Else "Name"
Hi Jonas,
I'm really sorry.
Its like, if we encounter any of the Null or Filter count >1 , then "Dept" else name.
Its wokring with or statement, but the problem is, only for few records, i'm gretting both the name and Dept.
which is strange.
Can you share some sample data where it is not working?
another one:
If(IsNull(Name) or [Filter Count], Dept, Name) as [New Column]
hope this helps
regards
Marco
Hi,
Try this
IF(LEN(Name) = 0 OR ISNULL(Name) AND count([Filter Count]) > 1, Dept, Name) AS [New Col]
try this
IF(Isnull(Name) or Filter count" >1 ,Dept,Name) as [New Column]
or
IF(Isnull(Name) ,IF( Filter count" >1 ,Dept,Name)) as [New Column]
Thanq sunil.
all the solutions worked.
Thanq Gabriel.
Thanq Marco.