Prepopulate Integer, Decimal and Currency fields within tables with a 0
Summary rows or columns in tables dont always calculate correctly if cells are left blank. Prepopulating integer, decimal and currency fields with a 0 would increase the accuracy of reports created with summary fields.
I have attached a image of a section of our zip code table. I have found that not completing all of the cells throws off the summary calculation. I end up finding these errors in our custom reports and have to go back and fill in a zero for the unanswered question to correct the sum.
1
vote
Craig Biehle
shared this idea