Metrics - how to handle leap year in daily measures?

4 posts 0 new
Log in or register to post comments.

Metrics - how to handle leap year in daily measures?

I have a measure that has daily values and I want to create a formula to show the value of the same day last year. Does e.g. ACT(-365) also work for leap years?

ACT(-365) doesn't take leap years into account. This could be done by having nested IF functions for first determining if the current year is a leap year, and if it is, then defining ACT(-366) to be used in the formula, otherwise ACT(-365) would be used.

Is there any alternative besides having to go through the value settings and change all the actual last year settings?

I don't think there is. Maybe someone else has some other thoughts on the matter.