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