1 Reply Latest reply: Jul 23, 2012 10:36 AM by Martina Brenner RSS

    Annualize Expression

    Rebecca Molstad

      I need to annualize an expression that sums up 2012 Revenue YTD. I would like it to take the 2012 Revenue YTD, divide it by the number of work days that have passed in the year, and multiply that by the total number of work days in the year. Is there a way to do this in the expression so that I won't have to change the divisor manually everyday?

       

      I have attached an example of my data.

       

      Thanks!