Error in Case statement in Beastmode

user077928
user077928 Member
in Magic ETL

Hi there, I'm getting this error when creating a case statement in Beast mode. Hoping someone can help? 

 

Invalid Formula : A column in this calculation did not exist.

 

This is the case statement. It's pretty simple, and the column definitely exists in the dataset, so I'm not sure why it won't work. 

 

CASE
when `Active days` >= 90 then "90+ Days"
when `Active days` >= 60 then "60-90 Days"
when `Active days` >= 30 then "30-60 Days"
when `Active days` < 30 then "<30 Days"
end

Best Answer

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    The issue is that you are using double quotation marks in your then statement. It should be single quotes like this:

    CASE
when `Active days` >= 90 then '90+ Days'
when `Active days` >= 60 then '60-90 Days'
when `Active days` >= 30 then '30-60 Days'
when `Active days` < 30 then '<30 Days'
end
    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Answers

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    The issue is that you are using double quotation marks in your then statement. It should be single quotes like this:

    CASE
when `Active days` >= 90 then '90+ Days'
when `Active days` >= 60 then '60-90 Days'
when `Active days` >= 30 then '30-60 Days'
when `Active days` < 30 then '<30 Days'
end
    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • user077928
    user077928 Member

    facepalm. thank you.

Categories