1 Reply Latest reply: May 7, 2013 5:57 AM by Gysbert Wassenaar RSS

    "Accrual" Formula

      Hi,

       

      I have a formula related to budget compsumption and I want to know, for any given day the information is accessed to, how much of the year budget "belongs", accumulated, to that given day.

       

      The logical formula would be something like = YearBudget * (# of days already past in the year, as of today)/ (Total # of days of the current year)

       

      I would like to define said variable in a way that I could add it to any given expression in order not to worry about updating its value.

       

      I thought about defining it from the script editor but I don´t have the slightest idea how to do it.

       

      I would really appreciate any help (or the straight formula ;-DD)

       

      Thank you very much.

       

      Regards.