Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Time Series Calculations - Using a Count Measure for YTD

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
-
RSUM isn't quite working as well.
0 -
Just wanted to follow-up to see if anyone might be able to help.
0