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 12.2.1.1.0

       

      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)

       

      Thanks

      Ebin