02-19-2015 05:55 AM
Been experimenting with this function a bit on a data set, containinig several rules per date. There's 12 dates per year, one for each month. In the report these lines are aggregated automatically . Somehow the ytd function works as expected for only the first to months of each year.
Does anybody have an idea why this is happening?
02-19-2015 10:17 AM
There is a parameter in the Year to Date aggregation that is set to "_ToToday_" by default. As a result, the Year to Date function only computes the cumulative sum up until February 19th (today's date) for each year. Edit the aggregated measure and set this parameter to "_Full_" if you wish the Year to Date function to compute the cumulative sum throughout the entire year.