Beast Mode Code

HelenOBrien

I am trying to write the following Beast mode code

If a date field is blank then "CAPA Phase" else it is "Implementation Phase " the following case statement will not work 

 

 

case when `PA_PLAN_DUE_DATE`='' then 'CAPA Phase' else 'Implementation Phase' end

Gimli

Hello, 
In order to call upon NULL values in a beastmode you refer to them using the key word NULL. 

For example: 

CASE WHEN `date` IS NULL THEN 'x' ELSE 'y' END

If this does not fix the issue you are experiencing you can email our great support team at [email protected] 

HelenOBrien

 how do I work with null dates in DOMO (Beast Mode)

 

I need to say if date is null then x else y 

 

please help 

Gimli

Hello, 
In order to call upon NULL values in a beastmode you refer to them using the key word NULL. 

For example: 

CASE WHEN `date` IS NULL THEN 'x' ELSE 'y' END

If this does not fix the issue you are experiencing you can email our great support team at [email protected] 

kshah008

@HelenOBrien, did ilikenno's reply help you out?

HelenOBrien

this is great -bIG tHANKS 

CASE WHEN `date` IS NULL THEN 'x' ELSE 'y' END

 

user03674

I'm trying to add another command in this statement, but it isn't working. does elseif not work?

 

Case
When
`ACTUAL_START_DATE` is null then 'Tracking'
elseif 'ACTUAL_START_DATE' is not null and `ACTUAL_END_DATE` is null then 'In Process'
else 'Completed'
End

Valiant

Case
When
`ACTUAL_START_DATE` is null then 'Tracking'
WHEN 'ACTUAL_START_DATE' is not null and `ACTUAL_END_DATE` is null then 'In Process'
else 'Completed'
End

Just change elseif to WHEN instead

 

That should work for you,

Valiant