Combine two colums in a formula

Question

Dear All,

just starting with Alteryx and having some difficulties with a formula. I'm trying to combine two columns but i'm getting a error message  malformed if statement.

When the results of vitamin c in not present then zero but when there is then combine two columns, vitamin C and the UOM (like 0,3 mg)

IF [VITAMINE_C] = 0 THEN 0 ELSEIF [VITAMINE_C]+[UOM_VITAMINE_C]
ENDIF

Thanks for the help

LordNeilLord · Accepted Answer

Hey @Barrypol1976

You always need to have an "else" in your IF statement

So something like IF  [VITAMINE_C] > 0 Then [VITAMINE_C]+[UOM_VITAMINE_C] Else 0 Endif

Barrypol1976 · Accepted Answer

Neil,

thanks for your quick reply. I'm still having some troubles. Hopefully you can check it one more time, thanks for your time.

JulioMO · Accepted Answer

Hi @Barrypol1976 ,

The operator "greater or equal" should be written as >= instead of =>.

Regards