Charting Monthly Trends

building reports desktopintelligence
1

Hi

I am trying to chart the % difference month on month in BOXI, but cannot quite figure out how to calclutate this.

I need to create a formula that takes each month’s revenues away from prior month revenues divided by prior months. So starting from Jan08 up to Current YTD 09.

Eg.
(Jan08 revenues - Dec07 revenues) divided by Dec07 Revenues OR
(Mar09 revenues - Feb09 revenues) divided by Feb09 Revenues OR
(Sept09 revenues - Aug09 revenues) divided by Aug09 Revenues

Can anyone help please

Many Thanks in advance

Maria

maria.n (BOB member since 2009-08-14)

2

Hi,

Use Previous() function, something like:

( <revenue> - Previous(<revenue>) ) / Previous(<revenue>)

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

3

Hi Marek

How do i define previous revenue?

the only variable i think i can use is date. So eg

= If (=‘6/1/2008’)
Then ((( Where (=‘6/1/2008’)) -
( Where (=‘5/1/2008’)))/
( Where (=‘5/1/2008’))) Else 0

But its not computing any numbers

Thanks

Maria

maria.n (BOB member since 2009-08-14)

4

Hi,

Create 3-columns table. Put and in the first 2 columns. And put Previous() in the last column. Check what the last column show and how you could use it for the calculation.

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

5

Perfect Marek

Thank you so much for your help

Kind Regards

Maria

maria.n (BOB member since 2009-08-14)