Formula Based on Previous Cell, is this possible?

building reports webintelligence
1

Hello,

I have a request to build a report in BO that contains a formula based on values from cells in a previous column. Please see the attachment for clarity. Is there some formula I can use, like [month([Date]) - 1] to recreate this formula in BO? Any ideas?

Thanks for the help!
Bobq1.doc (323.0 KB)

jmfuller (BOB member since 2010-02-16)

2

Hi,

Have you tried Previous() function?

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

No, I didn’t know about that function. It seems to be getting me close to my solution, I’ll let you know what I come up with.

Edit –

Ok, the previous() function is working to get the initial forecast number. Now, the next cell in the same row uses a formula that pulls from the initial forecast number. Is there a way to make one row use multiple formulas?

jmfuller (BOB member since 2010-02-16)