Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi,
there are two nice functions:
networkdays()
and
DayNumberOfYear()
Greetings from Munich
Martina