Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Accounting logic conversion from Excel to Oracle for recursive data usage

ORA_CAREOct 14 2016 — edited Nov 3 2016

Dear Forum members,

I've to calculate the projections for the accounting data making use of the previous (LAG)record and future record (LEAD) record, Also there is logic which inter depends on each other.

I've attached the sample data in spread sheet by applying the excel logic, so the logic for first record is different the rest of the records as we are projecting the data.

Please have a look at the attached sample data and please advise me with your ideas to use the logic in this scenario.

Below are the sample example logic for the excel version of calculation:

Cell F3 =F2-J3-D3

Cell G3 = F2*(E3-E2)/E2

Cell H3 = F2*B2-C3

Cell I3 = D3-G3

Cell J3 = -(H4+I4)

Thanks in advanceimage.PNG
This post has been answered by Etbin on Nov 2 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 1 2016
Added on Oct 14 2016
43 comments
4,820 views