Note 2: Also be careful and check your data types for these two fields.
Both fields should be a decimal data type. in tableau
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.
To ensure that two fields are of a decimal data type in Tableau, follow these step-by-step instructions:
1. Open your Tableau workbook and navigate to the "Data" tab.
2. In the data pane on the left-hand side, locate the fields that you want to check and modify.
3. Right-click on the field you want to modify and select "Default Properties" from the context menu.
4. In the "Default Properties" submenu, click on "Number Format".
5. In the "Number Format" dialog box, you will see various options for formatting the field. Select the desired decimal format, such as "Decimal Number" or "Fixed Decimal".
6. Specify the desired number of decimal places by adjusting the slider or typing the desired value.
7. Click "OK" to apply the changes and close the dialog box.
8. Repeat the same steps for the second field that you want to modify.
By following these steps, you will ensure that both fields are set to a decimal data type in Tableau.