I have a number field and I am using a formula to print string '-' when there is null value. I could remove decimals and zero's in the Cstr function. Now how can I sort this column.
If isnull({tablename.fieldname}) then
formula = "-"
else
formula = Cstr({tablename.fieldname},0,"")
end if
Please share any ideas how can I acheive this?
I used to show all zero's before, even for the null's in the database. users wanted me to show '-' for Null and show 0 for 0 in the database.
If isnull({tablename.fieldname}) then
formula = "-"
else
formula = Cstr({tablename.fieldname},0,"")
end if
Please share any ideas how can I acheive this?
I used to show all zero's before, even for the null's in the database. users wanted me to show '-' for Null and show 0 for 0 in the database.