View Single Post
Old 12-25-2024, 06:24 PM   #767
chaley
Grand Sorcerer
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 12,471
Karma: 8025600
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
Quote:
Originally Posted by ownedbycats View Post
For numerical columns, is there a better way to equal 0 while excluding nulls?

Code:
	elif (percent >=#1 && percent <=#99||$$#lastread !='None' && percent ==#0 && percent !='None')
	then 'currentlyreading'
You don't say where you got "percent". If it comes from a $$#something then I would use
Code:
raw_field('#something', -1)
that ensures that if #something isn't defined then the value of percent is -1.
chaley is offline   Reply With Quote