Hello all,

I'm trying run a query to do some calculation. If field2 and field3 have zero value it throws an exception. Can anyone kindly give some insight as how to work around.

sum(1)*MAX(field2)/MAX(field3)

thanks,