Create a calculated field called DTI
○ This field represents the debt-to-income ratio. You will calculate it by taking the
Total Debt variable and dividing it by Total Annual Income calculated in the
previous step. We want a percentage, so in the calculated field, multiply your
answer by 100 and round to 2 decimal places.
To create the calculated field called DTI, follow these steps:
1. Open your spreadsheet or data analysis software (e.g., Excel, Google Sheets, Tableau).
2. Identify the column or variable that contains the Total Debt values. Let's assume it is named "TotalDebt."
3. Identify the column or variable that contains the Total Annual Income calculated in the previous step. Let's assume it is named "TotalIncome."
4. Add a new column to your data table or dataset. Title this column "DTI."
5. In the first cell of the "DTI" column (e.g., cell C2), enter the following formula:
=ROUND((TotalDebt / TotalIncome) * 100, 2)
Note: The formula divides the TotalDebt by TotalIncome, multiplied by 100, and rounds the result to two decimal places using the ROUND function.
6. Press Enter to calculate the DTI for the first row.
7. The formula will automatically populate the DTI column for all other rows in your dataset, applying the same calculation to each row's respective TotalDebt and TotalIncome values.
Now, the DTI column will display the debt-to-income ratio as a percentage for each individual or record in your dataset.
in tableau
To create a calculated field called DTI in Tableau, follow these steps:
1. Open your Tableau workbook and navigate to the Worksheet where you want to create the DTI field.
2. In the top menu, click on "Analysis" and then select "Create Calculated Field."
3. In the calculated field dialog box that appears, enter the following formula:
ROUND(([Total Debt] / [Total Annual Income]) * 100, 2)
Note: Replace [Total Debt] and [Total Annual Income] with the actual field names in your Tableau dataset that contain the corresponding values.
4. Click on "OK" to create the calculated field.
5. Tableau will create a new field, which you can rename as "DTI" by clicking on the field's dropdown menu and selecting "Rename."
6. Now, you can drag and drop the "DTI" calculated field onto your worksheet to display the debt-to-income ratio for each data point.
Tableau will automatically calculate the DTI by dividing the Total Debt by Total Annual Income, multiplying it by 100, and rounding the result to two decimal places. The calculated field will be applied to each record in your dataset, providing the respective DTI ratio.
To create a calculated field called DTI to represent the debt-to-income ratio, follow these steps:
1. Identify the Total Debt variable and the Total Annual Income calculated in the previous step.
2. Divide the Total Debt variable by the Total Annual Income.
3. Multiply the result by 100 to convert it into a percentage.
4. Round the answer to 2 decimal places.
By following these steps, you will have created the calculated field called DTI that represents the debt-to-income ratio.