problem converting boolean to string 1

[chrisgeek]

I am working with a report that I need to sort by items that have not been charged. In this case the "is charged" field is a boolean with an answer of Yes or left null. The select expert doesn't work with false as the field is null. When I try to use Cstr it tells me the formula must result in a number. I'm sure that I'm missing something simple but any help you can give is greatly appreciated.

Thanks

 

[Charliy]

(if {table.ischarged} then "YES" else "NO")

 

[kskid]

To handle the null,

if isnull({table.ischarged}) then
"NO"
else if {table.ischarged} then
"YES"
else
"NO"

The last else will set to "NO" in the event {table.ischarged} is set to False.