Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Calculate past week sales from last year

Received Response
12
Views
1
Comments
User_YQZHD
User_YQZHD Rank 2 - Community Beginner
edited Aug 13, 2024 7:10PM in Oracle Analytics Cloud and Server

Hello,

I have a requirement to calculate sales as below

  1. Past week in current year
  2. 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:

Answers