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

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?

Answers

  • 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.

  • 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! **