AnsweredAssumed Answered

Calculation script based on a number field

Question asked by C.Kobel on Dec 5, 2012
Latest reply on Feb 1, 2013 by philmodjunk

Title

Calculation script based on a number field

Post

     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:

Table
     Annual  

Fields
     Vol_Jan, Vol_Feb, Vol_Mar, Vol_Apr, etc.
     Vol_Total 12 months


     I was hoping to have a calcuation that was basically

     Case(Get(CurrentDate)=Jan; Vol_Dec+Vol_Nov+Vol_Oct...Vol_Dec;Get(CurrentDate)=Feb;Vol_Jan+Vol_Dec...)

     I can tell it's all wrong but can't tell how to set it up correctly. Please help!

Outcomes