Skip to Content
0
Former Member
Apr 23, 2015 at 07:52 PM

Calculate Previous Value

14 Views

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