FABS with variable?

[cbaqir]

When I copied this expression into a text box, I see Error: Error in expression: ')' expected.

=IF(($(vForecastRound)=0 and $(vActualRound)=0), IsNull(Null()), IF(FABS($(vNewVariance))>1,0, 1-FABS($(vNewVariance))))

I think the issue is related to FABS($(vNewVariance)) because this alone gives me the same error. Does FABS() not work in this case for some reason?

Thanks,

Cassandra

[cbaqir]

OMG, I feel like an idiot... Thanks, Rob!

[sinanozdemir]

Thanks Rob.

I was driving myself crazy without realizing this.

[cbaqir]

Tell me about it!

[sinanozdemir]

I blame it on Friday

[rwunderlich]

It's a bit of an odd one that trips me sometimes. I added an additional comment about removing the Expression label to debug. That's usually the first place to start anytime $() is involved.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[cbaqir]

Thanks for your help!