Survey banner
Share your feedback on the Dataiku documentation with this 5 min survey. Thanks! TAKE THE SURVEY


Level 2

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. 

0 Kudos
1 Reply

Hi @David_Mellamphy ,

In a  prepare recipe processor

formula syntax

Something like this, if I understand correctly : 

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

0 Kudos