calculation that returns boolean

[bucky]

Does framework manager support returning boolean values for a calculation? I'm trying to do something like this:

if (...)
then (true)
else (false)

But it's invalid.

[angela]

It absolutely should work.  The problem might be with your actual calculation or where you're putting it - directly in the SQL or in a Calculated Column.

[blom0344]

AFAIK an if then else will always yield a value (whether 0/1 or any other combo) Since it will return either 1 of the values you can treat it like a Boolean I guess

[rockytopmark]

True and false are just strings in context for which you are using them.  Your syntax is invalid since you don't have single quotes around the string values.

If(...)
Then('True')
Else('False')

As Blom suggested, treat it like a boolean, but it will not be a true boolean in the data type sense.