## Forum Discussion

MarkShnier__You

Qrew Legend

One way to fix this is to fix the [Lunch Formula] field so that it calculates to a zero instead of a blank when the employee did not take a lunch. But if you want to kind of patch your existing formula you can do this

The function Nz (.....) Will convert any Null values into a numeric Zero

------------------------------

Mark Shnier (YQC)

mark.shnier@gmail.com

------------------------------

**Total Day Worked=**[Time Worked Formula] -**Nz(**[Lunch Formula]**)**The function Nz (.....) Will convert any Null values into a numeric Zero

------------------------------

Mark Shnier (YQC)

mark.shnier@gmail.com

------------------------------

CassieHubble

3 years agoQrew Cadet

Thanks, Mark that worked perfectly!

------------------------------

Cassie Hubble

------------------------------

------------------------------

Cassie Hubble

------------------------------