How to write this formula in datiku?

Solved!
prash_
Level 3
How to write this formula in datiku?

IF [ASIA]=0 THEN "CERO"
ELSEIF [ASIA]<=1 THEN
IF [ASIA]>=-1 THEN "DENTRLRANCIA"
ELSEIF [ASIA]>0 THEN "DIFERETIVA"
ELSE "DIFERENTIVA" ENDIF
ELSEIF [TOTAL]=0 THEN "DIOT"
ELSEIF [TOTTABLE]=0 THEN "CONTABLE"
ELSEIF [ASIA]>0 THEN "DIFER POSI"
ELSE "DIFERNEGVA" ENDIF

0 Kudos
1 Solution
Turribeach

It depends. Where you need it? Python Recipe, Prepare Recipe Formula, etc. Also your code doesn't have any tabulation so it's imposible to understand the else/elseif clauses. 

View solution in original post

0 Kudos
3 Replies
Turribeach

It depends. Where you need it? Python Recipe, Prepare Recipe Formula, etc. Also your code doesn't have any tabulation so it's imposible to understand the else/elseif clauses. 

0 Kudos
prash_
Level 3
Author

can you provide any such query in prepare recipe?

0 Kudos
Turribeach

I can but you need to paste a properly formated code sample. Use the code button to insert the code in a properly formatted way. 

0 Kudos