2086043 - Annualisation of partial years - WFP

• The annualised figure for the year to date adds the totals for the months so far and then divides by the fraction of the year that has passed.  Is it possible to apply this calculation at points other than the most recent month in the data?

• The automatic annualisation only applies to the period up to the most recent month in the current year.  To do the same for previous periods, for example up to the month before, involves manually adding together the appropriate monthly totals and finding the correct factor/divisor.  This can potentially be done using a composite query, though it may need to be adjusted after refreshes depending on the implementation.

KBA , LOD-SF-WFA-WA , Workforce Anaytics , How To