Calculation script based on a number field
I'm trying to create a script that will calculate the total number of referrals (volume) from the previous 12 months. I currently have one table with each record being one year and with each month in a separate field. I can't figure out how to make it work, so I'm assuming that means I've set my tables up wrong.
Just wondering what the best way to do this might be.
I currently have:
Vol_Jan, Vol_Feb, Vol_Mar, Vol_Apr, etc.
Vol_Total 12 months
I was hoping to have a calcuation that was basically
I can tell it's all wrong but can't tell how to set it up correctly. Please help!