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.