Why does If statement show Null

[#1]

if(Year(Opportunity.CreatedDate) = $(vCurrentYear),

     if(Year(Quote.CreatedDate) = $(vCurrentYear), 

          if(Quote.GrandTotal >= 0, 1, 0))) as Quotes

Why does this come back Null?

This is off a resident load.

[m_woolf]

I'll state the obvious:

     Year(Opportunity.CreatedDate) <> $(vCurrentYear

or     Year(Quote.CreatedDate) <> $(vCurrentYear)

[jagannalla · Accepted solution]

Hello,

1. If Year(Opportunity.CreatedDate) = $(vCurrentYear) is false then it takes null.

2. If if(Year(Quote.CreatedDate) = $(vCurrentYear) is false then it takes null.

3. If both conditions are true then it enters the third condition. Here if the condition is true then it holds 1 otherwise 0.

But in first two conditions if it is false it stores Null values.

Cheers!!

Jagan