I would like to raise an issue regarding snapshot data output. I have created a small database to illustrate the issue.
We want to monitor stock, we have enabled a daily snapshot to provide the “Syncmoment”. The design is very simple as below:
Please take note of highlighted rows as will be discussed below. I have assigned the syncmoment as the date and then built the database.
With this generated we see these results:
The highlighted amounts (TOTAL) is where the issue arises. The total is adding up each day to give you a total, with stock on Part A we had 100 which then went to 50, therefore the total based on the date range above would be actually 0 not 50. These are known as semi-additive measures, where the total is actually the latest value based on the date range. If for example I changed to the 16 & 17th only, the total would be 50. The total that Phocas is displaying is a simple sum of the periods being reported on. This causes numerical inaccuracies in the results. Since there is no means of turning off the total column (raised as another feature request here) there needs to be a means of the total displaying the correct value or disabling the total all together.
Please let me know if I am missing something on snapshot data as in its current structure it makes stock analysis difficult to display to end users.