Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Annualize Expression

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!

1 Reply
brenner_martina
Partner - Specialist II
Partner - Specialist II

Hi,

there are two nice functions:

networkdays()

and

DayNumberOfYear()

Greetings from Munich

Martina