ConsolidationDay to 'Wed, Fri' for 'Spektra' and fill null values for this?

madelynwogomon
madelynwogomon Member
in Beast Mode

I am trying to create a beast mode where when the customer = 'Spektra' then the ConsolidationDay = 'Wednesday, Friday'. I also need this to populate the ConsolidationDay cells with 'Wednesday, Friday' as they are currently null.

What would be the correct Beastmode to do this?

Best Answers

  • DavidChurchman
    DavidChurchman Coach
    Answer ✓

    It's a little unclear what you want ConsolidationDay to be when the customer is not 'Spektra', but otherwise, this should work:

    CASE

    WHEN customer='Spektra' THEN 'Wednesday, Friday'

    ELSE 'What you want ConsolidationDay to be when the customer is not Spektra'

    END

    If you want it to be null when the customer is not 'Spektra', then just delete that ELSE line.

    Please 💡/💖/👍/😊 this post if you read it and found it helpful.

    Please accept the answer if it solved your problem.

  • ArborRose
    ArborRose Coach
    Answer ✓

    Tweaking that a bit…

    CASE
    
    WHEN `Customer` = 'Spektra' AND `ConsolidationDay` IS NULL THEN 'Wednesday, Friday'
    
    ELSE `ConsolidationDay`
    
END

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

Answers

  • DavidChurchman
    DavidChurchman Coach
    Answer ✓

    It's a little unclear what you want ConsolidationDay to be when the customer is not 'Spektra', but otherwise, this should work:

    CASE

    WHEN customer='Spektra' THEN 'Wednesday, Friday'

    ELSE 'What you want ConsolidationDay to be when the customer is not Spektra'

    END

    If you want it to be null when the customer is not 'Spektra', then just delete that ELSE line.

    Please 💡/💖/👍/😊 this post if you read it and found it helpful.

    Please accept the answer if it solved your problem.

  • ArborRose
    ArborRose Coach
    Answer ✓

    Tweaking that a bit…

    CASE
    
    WHEN `Customer` = 'Spektra' AND `ConsolidationDay` IS NULL THEN 'Wednesday, Friday'
    
    ELSE `ConsolidationDay`
    
END

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

Categories