formula

[David_Mellamphy]

Hi I want to add a prepare recipe / formula to add column 1 + column 2 values, then subtract column 4 and 5, and give me the answer in another column, I know that in this example the results will be zero however I will have results where there will be differences. 

[AlexT]

Hi @David_Mellamphy ,

In a  prepare recipe processor https://doc.dataiku.com/dss/latest/preparation/processors/formula.html

formula syntax https://doc.dataiku.com/dss/latest/formula/index.html

Something like this, if I understand correctly : 

(numval("column 1")+ numval("column 1")) - (numval("column 4")+ numval("column 5"))