Previous Validated Formula now Domo is not accepting

KelNavarro_1206
KelNavarro_1206 Member
in Beast Mode

Please help: I have a beastmode calculation setup before that creates a Date using month number but now Domo is not accepting it.

Here is the formula:

DATE(CASEWHEN LENGTH(`Month Number`)=1 THEN CONCAT(`Year`,'-0',`Month Number`,'-01')ELSE CONCAT(`Year`,'-',`Month Number`,'-01') END)

This is the error message that I am receiving:

image.png

Answers

  • ggenovese
    ggenovese Contributor

    It looks like your Month Number is "0" and that's what's causing the issue. Do you see any records in your data that might have a Month Number = 0?

  • ArborRose
    ArborRose Coach

    I concur with @ggenovese. Your month number zero is producing invalid values.

    DATE(CASE 
    
    WHEN LENGTH(`Month Number`) = 1 THEN 
    
        CASE 
    
            WHEN `Month Number` BETWEEN '1' AND '9' THEN CONCAT(`Year`, '-0', `Month Number`, '-01') 
    
            ELSE NULL 
    
        END
    
    WHEN LENGTH(`Month Number`) = 2 THEN 
    
        CASE 
    
            WHEN `Month Number` BETWEEN '10' AND '12' THEN CONCAT(`Year`, '-', `Month Number`, '-01') 
    
            ELSE NULL 
    
        END
    
    ELSE NULL 
    
END)

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

Categories