Calculate Previous Value

[Former Member]

Hello

I am relatively new to Business Objects. My company currently uses Xi and I am stumped as to how to calculate a previous value and then use that calculated value in another field. For Example:

	Jan 2013	Feb 2013
A/R	100000	110000
Beginning A/R	300000	310000 (From Jan 2013 Ending A/R)
Collections	90000	100000
Ending A/R	310000	320000

Jan 2013 Beginning A/R value is hardcoded.

Ending A/R = Beginning A/R + A/R - Collections

Next Month Beginning A/R = previous month's Ending A/R

Any ideas or assistance is greatly appreciated.

Thanks

[Former Member · Accepted solution]

Hi,

You can use following formulas:

in beginning A/R cell:

= if isnull(previous(Endig A/R)) = 1 then beginning A/R else previous(Endig A/R)

[Former Member · Accepted solution]

Thanks for pointing me in the right direction.

In order to get it to work correctly I had to include RunningSum:

Starting AR Calc:

=If([Min MonthYear] = 1) Then (Beginning AR) Else (RunningSum(Previous([Beginning AR] +Sum([Collections])+Sum([A/R]))))

Ending AR Calc:

=If([Min MonthYear] =1) Then ([Beginning AR] +Sum([Collections])+Sum([A/R])) Else RunningSum( Previous([Beginning AR] +Sum([Collections])+Sum([A/R])))+Sum([Collections])+Sum([A/R])