Forum Discussion
Difference between two values
Hi Team,
I have a query , In a table one column contains target and actual values, i want a column with the difference between target and actual value.
Regards,
Suresh Pantra.
5 Replies
Ofcourse!
First select the table you want the new calculated column to be part of.
Second go to the modeling tab and click new column
At last you need to fill in the code:
and then you get this:
To further breakdown the code:
Column = Table3[Actual] - Table3[Target]
Column = is the column name. you can change this to whatever you want. For example
Difference = Table3[Actual] - Table3[Target]
would work perfectly.
Table3[Actual] and [Target] are just the fields of your table. replace table3 with the table name of your own and Actual and Target with the correct column names.
Goodluck! :D