Hi All,
There's a checkbox in my db. If it's checked, I want to print "-Alternate Site". If it's not checked, I want it to print "-Production Site".
Am I correct in that there can be three values for a checkbox? Null, 0 and 1? I think it is Null until someone checks the box, then it is 1. If someone removes the check, then the value in the field becomes 0. Correct?
Anyway, the following formula is not working for me. It's giving me completely random results:
if isnull ({location.siteName}) then ''
Else
if {PlanSegment_Location.alternate} = 1
then '- Alternate Site'
else '- Production Site'
Can anyone figure out what's going on?
Thx.
There's a checkbox in my db. If it's checked, I want to print "-Alternate Site". If it's not checked, I want it to print "-Production Site".
Am I correct in that there can be three values for a checkbox? Null, 0 and 1? I think it is Null until someone checks the box, then it is 1. If someone removes the check, then the value in the field becomes 0. Correct?
Anyway, the following formula is not working for me. It's giving me completely random results:
if isnull ({location.siteName}) then ''
Else
if {PlanSegment_Location.alternate} = 1
then '- Alternate Site'
else '- Production Site'
Can anyone figure out what's going on?
Thx.