Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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")))
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.
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.
Thanks, this worked