Oracle AI and Analytics

User_YQZHD

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

User_I41H1

Try with this Ago(Sales,Week,52) or may be can be 53 weeks ago.