Creating Data Slice Having issues with Row Filter Condition

[anonymous]

I am trying to create a data slice with an AND(condition1,condition2) statement. It works if I use just:

[Uploaded] = “”

But when I try and weed out all artists with my name in it, it comes up blank.

AND([Uploaded] = “”,NOT(substitute(lower([Artist Name])," “,”") = “phiofkhem”))

Weird part is, if I use the Test button to test the slice, it shows validation as “Y” for my final row, which is expected, but it does not show in the preview window.

Any idea what I am doing wrong? Thanks so much for any help you can provide!

phi

[SkrOYC]

You want the rows that are not “phiofkhem”?
Seems like you are overthinking it.

If it’s a yes, this should work

AND(
  [Uploaded] = "",
  [Artist Name]<>"phiofkhem"
)

Now, if you really need what you did before, I would do it this way

AND(
  ISBLANK([Uploaded]),
  SUBSTITUTE(LOWER([Artist Name]), " ", "")<>"phiofkhem"
)

[anonymous]

Hey thanks for the help! I tried your solution and get back all rows in my table, but when changing to ‘[UPLOADED]=“”’ using your query gave me nothing back (it should give me back the last row, which has a different artist name and a blank cell for UPLOADED.

FYI - the reason I have the convoluted logic for the artist name is it can be any variation (phiofkhem, PHi of Kh em, P H I of Khem, etc.

Let me know if you have any other ideas, and thanks much for the help!!

phi

[Steve]

Don’t use [Uploaded] = “”; use ISBLANK([Uploaded]) instead.