Not Like Function

[Hillary]

Is there a function for not like that can be put into a formula? I have a field that has null, zero and positive integer values. I am trying to conditional format the positive interger values. The data is String type. In my formula I tried the ToNumber funtion so I could use >greater than but I get "The string is non-numeric" error even though there is nothing but numeric and null values. I would like to conditional format anything that is not like "" or "0".

Thanks for you help!

 

[goranm]

Hi !

Maybe you can try it this way:

if IsNull({table.field}) or ({table.field}) = "0" then
"whatever"
else
"your format"

/Goran

 

[Hillary]

Thanks Goran, the condition works.