6 Replies Latest reply on Feb 23, 2018 6:27 PM by Uttam.Singh

    Calculated Measure in AGO Function

    Ebin Cherian

      Hi All,


      Oracle Business Intelligence


      This is a question I received from 1 of the users. Users use AGO function at the report level on top of RPD measures and results are fine. Question is will AGO work for a calculated measure in answers. ?


      For example , user created a new measure in analysis say COUNT(DISTINCT "Transaction Details"."Document Number"). Then created a new column in report and gave the below mentioned formula.


      AGO(COUNT(DISTINCT "Transaction Details"."Document Number"), "Time"."Time"."Fiscal Year", 1)