Note 2: Also be careful and check your data types for these two fields.

Question

Both fields should be a decimal data type. in tableau

Answer 1

To ensure that both fields are set as decimal data types in Tableau, follow these steps:

1. Open your Tableau workbook.

2. Locate the data source tab and navigate to the relevant data table.

3. Identify the two fields that need to be checked and changed to decimal data types.

4. Right-click on each field one at a time and select "Change Data Type."

5. In the pop-up window, select "Decimal" as the desired data type.

6. Click "OK" to save the changes and close the window.

7. Repeat steps 4-6 for the second field.

8. Verify that both fields now appear as decimal data types in the data source tab.

9. Save your changes and proceed with your analysis or visualization using the decimal data type for the specified fields.

By ensuring that both fields are correctly set as decimal data types, you can perform accurate calculations and avoid any potential issues related to data type incompatibilities in your Tableau workbook.