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


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

     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!