Tableau Exam TDA-C01 Topic 9 Question 31 Discussion

Actual exam question for Tableau's TDA-C01 exam

Question #: 31
Topic #: 9

[All TDA-C01 Questions]

You have the following dataset that contain null values in the Profits field.

You want the data to appear as shown in the following table.

Which two formulas achieve the goal? Choose two.

A2N ([Profits])

BISNULL ([Profits])

CIFNULL [(profits] ,0)

DIF [Profits] != null then [Profits] END

EIFNULL([Profits],0) D. IF [Profits] != null then [Profits] END
The IFNULL function is a logical function that returns the first argument if it is not null, and the second argument if it is null. In this case, the first argument is [Profits], which is the field that contains null values. The second argument is 0, which is the value that you want to replace null values with. The function will return [Profits] if it is not null, and 0 if it is null.
The IF statement is a logical statement that returns a value or performs an action if a condition is true, and optionally returns another value or performs another action if the condition is false. In this case, the condition is [Profits] != null, which means that [Profits] is not null. The statement will return [Profits] if the condition is true, and nothing if the condition is false. The END keyword marks the end of the statement.
The other options are not correct for this scenario. The ZN function is a logical function that returns zero if a value or expression is null, and returns the value or expression itself if it is not null. However, it only works with numeric values or expressions, and [Profits] may not be numeric in this case. The ISNULL function is a logical function that returns TRUE if a value or expression is null, and FALSE otherwise. It does not replace null values with another value. Reference: https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#IFNULL https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#IF https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#ZN https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#ISNULL

Show Suggested Answer

Suggested Answer: C, D

The two formulas that will make the data appear as shown in the second table are:

by Evangelina at Nov 26, 2023, 04:05 AM

Limited Time Offer

25%

Off

Get Premium TDA-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!