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