Time Series Calculations - Using a Count Measure for YTD

Pete 17

Hello all,

I'm attempting to create a measure using the time series calculation of TODATE to achieve YTD numbers.

For example, if I need to achieve YTD invoice amounts the function of TODATE("- Invoice Amounts"."Invoice Amount","Fiscal Calendar"."Date - Fiscal Calendar"."Fiscal Year" ) works great. However, if I'm using a measure that counts something within the TODATE function, it does seem to work. For example, I want a distinct count of invoice numbers YTD and I'm using the formula of TODATE(COUNT(DISTINCT "- General Information"."Invoice Number"),"Fiscal Calendar"."Date - Fiscal Calendar"."Fiscal Year"). It will not sum the invoice count YTD, no matter if I set the aggregation rule to sum.

Is there someone that could provide some guidance on this?

Thanks in advance!

Pete 17

RSUM isn't quite working as well.

Pete 17

Just wanted to follow-up to see if anyone might be able to help.