If Statements

[cbaqir]

I need to write basically an elseif statement in an expression...

This works:

if(isnull($(vForecastVariance)), -1, $(vForecastVariance))

This doesn't:

=if(isnull(vForecastRound) and isnull(vActualRound),0, if(isnull($(vForecastVariance)), -1, $(vForecastVariance)))

I think it's a syntax error. Any suggestions?

Thanks!

Cassandra

[cbaqir]

Thank you!