Apologies if this has been answered previously but I have been unable to get a specific model to work.
I have a database table that needs to store some very basic info for a reporting system. The information fed to me is Date - Pallets-in - Pallets-out - Pallet_Count - Man_Hours
The report when created needs to show Date - Pallets handled (Pallets-in + Pallets-out) - Man-Hours - Avg PLTS per hour - Overall Pallets in warehouse
EG yesterday report might shows 14-03-2015 PLT-Handled 400 (300 in 100 out) - Man-Hours 36 - Avg Plts p/Hour 11.11 - Overall Plts inW/House 7300 (day before there were 7100 so add 300 in and remove 100 out)
I currently just compose this report manually but I want to try and do it in a database so we have better historical reporting ability. Do i just have a table that stores every part or would it be better to calculate some parts in the report generation. (I am unsure how to mainly include the Total pallets in warehouse as it calculated from a starting figure then add plts in minus plts out.
Hope the above mmakes some sense