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.

Alexandru

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"))