I am trying to create a production report for my work and all of the tasks that are done are counted for each employee. I have my data, my pivot, and my main dash that points all my data to go where I want it to go. The problem is, when someone does not complete a task for the day I get an error message when all I need it to say is "0". I have done research and cannot find the exact formula to apply to my excel report that will formulate a "0" for empty cells instead of an error message. Please help? Thanks
A step one solution might be the replace all the empty cells in you data with a zero. This can easily be done by highlighting the area. Then use find a replace; leave replace blank and add 0 to replace with. Not a great solution but it should help. You could then record a simple Marco to automate these steps.
I tried using Find and Select Special, then used blanks, but it won't let me replace all the values at once.