Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
I'll state the obvious:
Year(Opportunity.CreatedDate) <> $(vCurrentYear
or Year(Quote.CreatedDate) <> $(vCurrentYear)
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