We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

RSUM not giving expected results.

Received Response
5
Views
3
Comments
edited Sep 30, 2020 8:23PM in Reporting and Analytics for SCM 3 comments

Content

Hi. I made an OTBI report (check attached image) using the Cash Management - Bank Statements Real Time, Subject Area

I want to do a RSUM of each bank account to get the latest account balance, taking in consideration the flow and making it negative when a debit and keeping the sign when credit. (check code snippet).

And it's not working. It does bring results but have not found a pattern of what it does. Have no idea why. First time using this aggregation function in OTBI. I do use similar functions in SQL but here I'm not sure RSUM is partitioning well.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!