AnsweredAssumed Answered

if statement does not work correctly

Question asked by Doug McAllister on Dec 11, 2013
Latest reply on Dec 16, 2013 by Josh Brady

This if statement will not return a result:

"ID" = 1

"BD" = 2

"FK" = if("ID">"BD",sqr(("ID"/"BD")^2 - 1),0)

 

I am guessing that it is because both expressions in the if statement are evaluated, the sqr function fails and therefore the whole expression fails.  I think this bug was also present in SW 2010.  These are the sorts of things that caused me to let my subscription lapse for four years.

Outcomes