BusinessObjects Board

Show All Field In A CrossTab Summary

building reports desktopintelligence
#1

Consider the variable Summary Volume Sold being the formula that follows. Under that I have Volume Sold Count in a Crosstab.

= If (Year() < Year(CurrentDate()) Then “Prior Years” Else
If (Year() > Year(CurrentDate()) Then “Future Years” Else
If (Month) = “January”) Then "Jan "+ Else
If (Month) = “February”) Then "Feb "+ Else
If (Month) = “March”) Then "Mar "+ Else
If (Month) = “April”) Then "Apr " + Else
If (Month) = “May”) Then "May "+ Else
If (Month) = “June”) Then "Jun " + Else
If (Month) = “July”) Then "Jul " + Else
If (Month) =“August”) Then "Aug "+ Else
If (Month)=“September”) Then "Sep "+ Else
If (Month) = “October”) Then "Oct " + Else
If (Month) =“November”) Then "Nov "+ Else
If (Month)= “December”) Then "Dec "+

How can I force BO V6.5 to show all the Fields of Summary Volume Sold even if there is no count. For instance the Column Prior Years and Jan 2006 have counts, Feb 2006, does not have a count, Mar and Apr 2006 have counts but May 2006 does not have a count etc…

Thanks

dranerb (BOB member since 2006-06-16)

#2

Check out this FAQ.

Nick Daniels :uk: (BOB member since 2002-08-15)

#3

Next to that, I suppose you could easy limit the size of your code to:

= If (Year(<Submitted Date>) < Year(CurrentDate()) Then "Prior Years" Else 
If (Year(<Submitted Date>) > Year(CurrentDate()) Then "Future Years" Else 
If (Month<Submitted Date>) = "January") Then SubStr((Month<Submitted Date>),1,3)+<Current Year>

jobjoris :netherlands: (BOB member since 2004-06-30)