1 Reply Latest reply on Jul 20, 2015 11:25 AM by Daan Bakboord - DaAnalytics

    How do I recreate a lag function in 10g?

    ae689c21-597b-4403-8c29-f6fd098b2727

      Hey,

       

      I have a column formula that works through an evaluate function in 11g and I want to replicate in 10g, but it gives me an ERROR: [nQSError: 10058] A general error has occurred. [nQSError: 27005] Unresolved column.

       

      the formula in 11g :

       

      EVALUATE('LAG(%1,1,0) OVER (PARTITION BY %3 ORDER BY %2)',"Counts"."Net Accounts","Time"."Fiscal Period","Division Information"."Division").

       

      What I am trying to do is get the previous period's net accounts value by division.

       

      Essentially,

      Division - Fiscal Period - Net Accounts - Previous Period Net Accounts.

       

      I got it to work in 11g, but I need it as part of a report I need to do in 10g.