Submit your use case or success story to the 2023 edition of the Dataiku Frontrunner Awards ENTER YOUR SUBMISSION


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