Combine two colums in a formula

[Barrypol1976]

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

[RishiK]

Hi there

You have written your IF ELSE expression slightly wrong.  It should be:

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

[LordNeilLord · Accepted solution]

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 solution]

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 solution]

Hi @Barrypol1976 ,

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

Regards