TDA-C01 Exam - Question 40

Question

You have the following dataset that contains 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. ).

Examice · Accepted Answer

To ensure that null values in the 'Profits' field are replaced with 0, you can use two functions: IFNULL([Profits], 0) and ZN([Profits]). The IFNULL function checks if the 'Profits' field is null; if it is, it assigns a value of 0. The ZN function does the same by replacing null values with 0. These functions will ensure that the dataset will display 0 for any null values in the 'Profits' column, as shown in the second table.

84db7a1 · Answer

C and D are correct

MonBouj · Answer

C. IFNULL([Profits],0)
D. ZN([Profits])

TDA-C01 Exam - Question 40

Discussion