0

I'm trying to create a calculated field in Tableau - but for the below it says am missing an operator, how would it be?

IFNULL([Translator], [Translation Requestor 1])
THEN "NULL" 
ELSE "Not NULL" 
END
Catalina Tocasuchil
  • 13
  • 4
  • 1
    In simple English, what do you intend this formula to do? – Andy TAR Sols Jun 10 '21 at 09:50
  • 1
    The IFNULL function in Tableau checks the value of the first argument and returns it is it isn't null; if it IS null the second value is returned (you can check this in the live help available when creating the function). So all the THEN, ELSE END after it is redundant. – matt_black Jun 10 '21 at 11:08

1 Answers1

0

This should work: IFNULL([Translator], [Translation Requestor 1])

Anu
  • 306
  • 2
  • 11