By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,880 Members | 2,292 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,880 IT Pros & Developers. It's quick & easy.

Null Zero

P: 40
I am having issues putting null zero function on the above formula.
Expand|Select|Wrap|Line Numbers
  1. LaborHours: Sum(Left([ActualLaborHours],InStr(1,[ActualLaborHours],":")-1)+(Right([ActualLaborHours],InStr(1,[ActualLaborHours],":")-1))/60)
what i am trying to do when the query runs i want it to display 0 if is null or blank.
Nov 5 '18 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.