I have a field called status. I need to do a compare: if status is 'dead' then formula=false. if status is anything else, formula = true. There is a status value 'dead-spent'. I want the formula to be true when it's dead-spent but the way I have it written, it doesn't read past 'dead'. Does anyone know how i can differentiate the two? Status can have seven different values(active, inactive, etc....)
This is what i have so far & it's not working.
if instr({CUST.Status},"Dead",1)>0 then
formula = false
else
formula = true
end if
-Nancy.