Yearly Sum

building reports webintelligence
1

Hi,

In report I have 3 quarters for 2004 year and for rest , i have 4 quarters.

How I can calculate Total for 2004 year including Q1 … right now it displaying total for 3 quarters Q2,Q3 and Q4 only… Please

Thanks

BOCP (BOB member since 2007-07-02)

2

Hi,
It might be useful to post the formula you’re using to determine the quarter - whether it is in the universe or not, as well as the version of BOXI you’re using.

Are you sure you have data for that quarter?

Thanks.

David.Mitchell :uk: (BOB member since 2008-04-28)

3

Thanks for your response…!!

  1. It is there in Universe.
  2. version : BO XI- R3.0
  3. Yeah, I have data for that quarter.
 = If( [Year] = (ToNumber(Substr([Current Qtr];0;4)) -3 )) Then Round(((Sum([Rev- FY])/1000);0) Else [Rev-Qtr] 
 Year= Substr([Rev-Qtr];0;4) 
 current Qtr="2007-Q1"

I have 2 queries :

–> [Rev-Qtr] is from Qyery-1 by filtering “2004-Q1” quarter.
–> [Rev-Yr] is from Query-2 including “2004-Q1” .

Can anyone help me why it is not including 2004-Q1 value in total…?? Please

Thanks

BOCP (BOB member since 2007-07-02)