Calculation that nulls are in one field

[thorny00]

Using CR 10.0
Have the following formula. The hmsend field can have nulls in it. How do I account for the nulls in the formula?

{tblBatchMaster.RecCnt}/datediff("s",{tblBatchLog.HMSStart},{tblBatchLog.HMSEnd})

Thanks in advance for you time and help, I really appreciate it!

 

[synapsevampire]

Try:

if datediff("s",{tblBatchLog.HMSStart},{tblBatchLog.HMSEnd} = 0 then
0
else
{tblBatchMaster.RecCnt}/datediff("s",{tblBatchLog.HMSStart},{tblBatchLog.HMSEnd})

-k