4 Replies Latest reply: Jan 29, 2013 11:10 AM by Loren Wood RSS

    Rolling Monthly Average - In Script

    Loren Wood

      Hello everyone, I am trying to calculate the rolling average for the month (See attached file) (US Dollars to Euro)

      so if day 1 the rate is 1.4000 and day 2 the rate is 1.4500 day 2 avg rate will be 1.4250.  for Day 3 and the rate is 1.4600 and rolling average will be 1.4366 etc.

       

      This will need to change starting with first day of the month, so on Jan 1, the average starts new.

       

      Not sure how to get this going in the script so any help provided would be great

       

      Thanks