Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Looking for a function like RSUM which does the contrary

Received Response
11
Views
1
Comments
fabryddorf-Oracle
fabryddorf-Oracle Rank 4 - Community Specialist
edited Aug 13, 2024 5:12PM in Oracle Analytics Cloud and Server

Hi Guys,

I am trying to create a report for a customer which they will need for their finance system.

It is about a guest who does a pre-payment at arrival at the hotel. The hotel system will split the pre-payment by day, but they would like to see the balance brought forward and the balance carried forward.

I could achieve the balance brough forward by using RSUM (see sample), but the balance carried forward should do the contrary.

Attached a sample in xls for easy understing and the report in BI how it looks so far.


Any advice would be very appreciated

Regards

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Turn all your amounts other than the pre-payment into negative numbers and RSUM will work just fine.

    PS: as an Oracle employee you should setup your forum profile following the internal rules/policies (appending the "-Oracle" to the screen name etc.)