ISNULL clause with a condition

Transact-SQL
1

Hi,

I've got the following code to select the latest period where I have active data:
{ FIXED : MAX(IF NOT (ISNULL([Qty in tn])) THEN [Period] END)}

The problem I have is that the [Qty in tn] is only null when another column [Data Type] = "ACT". How do I modify the above code to take into account the second column?

Cheers!

Regards,

Yari

2

hi

case when column1 is null then column2 else column1 end

hope this helps !!! :slight_smile:

3

Hi,

Not sure if it would work. I only need this to check when exactly the [Qty in tn] column is null when the [Data Type] column is "ACT"...

Best regards,

Yari

4

case
when [Data Type] = "ACT" and [Qty in tn] column is null then
"what you want to do"