Adding Previous balance to current balance

building reports webintelligence
1

I am trying to create a a cross tab report which displays the current balance which is made up of the previous month balance.

A 10
B 5
Balance= A-B + Prevuious Months Balance

I have tried using, Previous Month Balance=if(month=previous(month);Balance) and add this to the current balance, but to no avail.

I have attached a spreadsheet explaining the cross tab I am trying to create.

Many Thanks
Pre Month Balance.xls (24.0 KB)

nicktucker :australia: (BOB member since 2006-03-09)

2

The example is a bit ambiguous - what are your measures and Dimensions?

mcnelson :uk: (BOB member since 2008-10-09)

3

Thanks for your reply.

In my example, Inventory, PO and Sales are measure objects, where Balance is the calculation as stated, PO-Sales+Previous Months Balance.

Thanks

nicktucker :australia: (BOB member since 2006-03-09)

4

Hi,

Create an object Balance at report level with definition as =[PO]-[Sales]

And in the report for Balance coloumn place the formula as =RunningSum([Balance])

See if this helps you

saurabhg :india: (BOB member since 2007-04-02)

5

Hi,

That worked :stuck_out_tongue: , I should have tried that, over complicating things again.

Many thanks for your help on this.

Kind Regards,

Nick

nicktucker :australia: (BOB member since 2006-03-09)