Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 19 Oracle Analytics Lounge
- 222 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 83 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Calculate past week sales from last year

User_YQZHD
Rank 2 - Community Beginner
Hello,
I have a requirement to calculate sales as below
- Past week in current year
- Past week in last year
For the 1st one, I was using AGO formula of Ago(Sales,Week,1 ) and it works well.
For the next one, I was trying Ago(Ago(Sales,Year,1 ),week,1) and it fails with error message of
"Nesting of EGO or TODATE functions with differing level argument is not supported" and I see why, since my formula has two levels, YEAR and WEEK.
Looking for inputs on how we can achieve the 2nd one.
Thanks
Tagged:
0
Answers
-
Try with this Ago(Sales,Week,52) or may be can be 53 weeks ago.
0