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

    How do I recreate a lag function in 10g?




      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.



      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.