Using formular in prepare recipe

Scobbyy2k3

I have a dataset i want to create a new column for using these parameters in prepare recipe

i want results that are null to show as missing in the new column

results with zero to show as missing

and result than zero as resulted.

Here is what I have come up with so far

if(RESULTS == "","MISSING", if(RESULTS == 0,"MISSING", if(RESULTS isNotNull("") ,"RESULTED")))

Vitaliy

Hi,

If I understood correctly, you don't need the third condition as from your description if the value is not empty or not 0 the output should be "RESULTED". Please refer to the formula below. If this is not what you were looking for, please provide a small sample of data together with the desired output.

if(isNull(RESULTS)||RESULTS==0,"MISSING","RESULTED")

Best.

Scobbyy2k3

Thanks, this worked