Time Series Calculations - Using a Count Measure for YTD — Oracle Analytics

Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Time Series Calculations - Using a Count Measure for YTD

Received Response
1
Views
2
Comments

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!

Answers