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 Explanation:
The two formulas that will make the data appear as shown in the second table are:

To apply a custom data role to a field, you need to select the data type of the field and then choose the data role from the list of available roles. This will validate the values in the field against the data role and mark any invalid values with a red exclamation mark. To fix the invalid values, you can use the Group Values option and select the Spelling algorithm, which will group values that are close in spelling and replace them with the most frequent value in the group. This will help you standardize the values in the Material field and match them with the Role1 data role. References: The information is based on the following sources:
* Use Data Roles to Validate your Data - Tableau
* New in Tableau Prep: Automatically identify data quality issues with Data Roles

To replace a sheet on a tiled dashboard, you can simply drag the new sheet from the Sheets pane to the dashboard and drop it over the existing sheet. This will replace the old sheet with the new one and keep the same size and position. Alternatively, you can right-click on the old sheet and select Replace Data Source, then choose the new sheet from the list. Reference: https://help.tableau.com/current/pro/desktop/en-us/dashboards_organize_floating_layoutcontainers.htm https://help.tableau.com/current/pro/desktop/en-us/dashboards_replace_datasource.htm