I'm trying to build a formula to check for (-1 or True) in an SQL Table field [Ftester]. As of now it looks like the following.

if {Productivity_MA_RUfinal.Ftester} = -1
then "FIXED"
else "VARIABLE"

The error I'm getting is says that A STRING IS REQUIRED HERE.

Any hints on how to resolve this?

CEJ

__________________
CEJ

Try:

if {Productivity_MA_RUfinal.Ftester} = "-1"
then "FIXED"
else "VARIABLE"

It should work...