Ago Function not displaying data for Prior Year Periods

Question

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 .

User_GQQ67 · Answer

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

Bhaskar Konar · Answer

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.