ZERO AND ‘N/A’ ARE DIFFERENT
Zero should be entered when the value is actually zero
‘N/A’ should be entered when you do not have a value
For example: If you are open to trade and have no visitors then recording a zero is a legitimate value. Similarly, if you receive visitors and make no sales, zero is the appropriate figure to enter against sales.
However, if you leave a cell blank an ‘N/A’ will automatically be inserted. You would leave a cell blank if you chose to close on a regular trading day (i.e. Christmas Day) or products usually available were no longer available for sale. Therefore the correct reporting value is “Not Available” because there is no value to report.
This distinction is important because it affects the way the reports are aggregated and presented. An incorrect value will skew the data and cause anomalies affecting the integrity of the reports. For the technically inclined, each ‘N/A’ is counted as a non-participation value and will reduce the participation rate, but will not be included in calculating the statistical value returned. Zeros are reported as a participating value that will increase the participation rate and be included in calculating the statistical value returned.
It’s also important to note that if you do not enter a positive value in Visitors Count, you will not be able to enter values in any other related cells (because the system assumes you had no visitors to sell to.)
If you require further clarification please contact us