Skip to Main Content

Oracle Analytics Cloud

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!

Cuumulative sum with starting balance

brenda_strongApr 4 2024 — edited Apr 4 2024

I am trying to get a column with a running balance. This is super easy with RSUM(amount). BUT…I need to have an opening balance that is not the first row, kind of like a check register opening balance.

Example:

(Sections)
Project #: 1234 Opening Balance: $500

Vendor ClaimNo ClaimDate AmtPaid Balance

001 234 01/01/2024 -24.00 476.00
001 235 01/02/2024 -39.00 437.00
002 236 01/03/2024 -50.00 387.00

This is Oracle Analytics analyses, so I can't use any window function in the analyses itself.

Does anyone know a way I can get this to work?

Regards

This post has been answered by Gianni Ceresa on Apr 4 2024
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked by Renae Stout-Oracle on Jul 8 2024
Added on Apr 4 2024
2 comments
457 views