Sum of first two blocks of a break implemented report

building reports webintelligence
1

Hi,

I have a requirement for calculating the Sum of first two blocks of a break implemented report.
For Example, Report has 5 years of data. 2005-2009. Breaks have been implemented on year.
Now i need sum of data of 2005 and 2006 only.

Thanks

avbaby :india: (BOB member since 2009-05-09)

2

The formula should be:

=Sum([measure data]) Where ([Year] InList(2005;2006))

JohnCW :us: (BOB member since 2004-08-05)

3

That was only the example… Years are not static. They are dynamic. Not necessarily 2005 and 2006

avbaby :india: (BOB member since 2009-05-09)

4

Are the requirements for the first two blocks static? For example, is it always “current year minus 4 years” or something like that? I would create some type of variable based on that to represent those first two blocks, and then use the example I provided.

JohnCW :us: (BOB member since 2004-08-05)

5

You can say its the sum of MIN of YEAR and (MIN OF YEAR)+1

avbaby :india: (BOB member since 2009-05-09)