Specifying a date in an expression so that only entries with that date proceed

[Michael Hall 4]

Hi,

I'm trying to create an expression for a calculated column that converts all of my units into megawatts, but with a few extra requirements as follows:

 

If something is classified in a certain way, the result is NULL, so that it doesn't interfere with a weighted average calculation later.

If it isn't a given date the result must also be 0 so that it doesn't interfere with the weighted average calc later (this is the problem step)

The rest of the calculation just converts all of my other units into Megawatts

 

 

Here's what I have so far:

The [Delivery date] column is"Date" data type, and is in dd/mm/yyyy format.

case

when [Classification] in ("aaa", "bbb", "ccc", "ddd", "eee", "fff", "ggg", "hhh") then NULL

if ([Delivery date]=Date(01/01/2019)

[Ryan Mireles 2]

Try making your [AMT UNIT] its own case Statement "[AMT UNIT SCENARIO]"

 

case

when [Classification] in ("aaa", "bbb", "ccc", "ddd", "eee", "fff", "ggg", "hhh") then NULL

when [Delivery date]!=Date(01/01/2019) THEN NULL

when [Delivery date]=Date(01/01/2019) THEN [AMT UNIT SCENARIO]

else 0

END