Subtract fields of a column - Tableau

Question

I would like to subtract promoters and detractors in Tableau by creating a new column. Thanks for all the help!

Customer Type Table (I would like to create the NPS field as shown below):

+---------+------------+----------+-----------+--------------+

| Quarter | Detractors | Passives | Promoters | NPS          |

+---------+------------+----------+-----------+--------------+

| Q1 15   | 40.56      | 23.56    | 35.79     | =35.79-40.56 |

| ...     | ...        | ...      | ...       | ...          |

+---------+------------+----------+-----------+--------------+

Answer 1

• Create a calculated field called NPS:

[Promoters] - [Detractors]

• By creating this, it will add a new field to every row of your partition called NPS.