Ago Function not displaying data for Prior Year Periods

User_GQQ67

Ago Function not displaying data for Prior Year Periods in OAC FDI DV.If user select Jan 26 , previous month data for Dec 26 is showing blank column .

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/27819/ago-function-not-displaying-data-for-prior-year-periods

Hi @User_GQQ67,

Please take a look into the following post which might be useful.

Query Error with AGO Function — Oracle

Hope this help.

Thank you.

User_GQQ67

Hi,

Thanks for the response , hope you have gone through the problem statement. Issue is with the AGO function where for Jan-26 , Dec-25 data is nor reflecting.

Function used AGO(Revenue, Fiscal period,1)

Regards