BusinessObjects Board

cut in many variable an object indicator

building reports desktopintelligence
#1

Hi everybody,

I have an object

And in reporter, i would like to create 3 Objects derived of Service Amount

  1. “Anytime Amount” with
    Inlist (‘Conference’,‘Playback’,Recoding’) and =0
  2. “Datanow Amount” with
    = Datanow and =0
    3.“Event Amount” with
    =1 AND
    Inlist (‘Conference’,‘Playback’,Recoding’)

I have created this objects with formulas : for the first
If Inlist (‘Conference’,‘Playback’,Recoding’) and =0 Then .

But in my report if i delete the object or
I have #CALCUL that appears in my “Anytime Amount”

How can I do to have my three colum without columns and
in my report ?
:wah:
Thanks in advance
Chris

Maitre B (BOB member since 2004-09-02)

#2

Apparently those columns are needed for BusinessObjects to perform the calculation. So, how about including them in the table, but hiding those columns? Right click on the table and choose Format Table. On the Pivot tab, you can select objects to hide in your table.

MichaelWelter :vatican_city: (BOB member since 2002-08-08)

#3

Forget about IF THEN… ELSE… and use the WHERE clause instead, see this work around in Reporter FAQ.

Andreas :de: (BOB member since 2002-06-20)

#4

With the WHERE clause (Où in French :slight_smile: )
I have an object “Anytime Amount”
= Où (=0 Et = "Conference " )

And I have two problems :
First : I have incoherent result
Ex :
Acc Name - Service Type - Is Event - “Anytime Amount”
Acc 1 - Conference - O - 20
Acc1 - Recoding - 1 - 20
Acc2 - Recoding - 1 - _

At the 2nd Lines I have a value because they are in the same Acc Name,
but the condition is not respected :nonod: recoding and not conference
:wah:

Second :
I cannot make a formula include the InList condition
Ex:= Où (=0 Et InList ‘Conference’,‘Playback’,Recoding’ )
:wah:

regards

Maitre B (BOB member since 2004-09-02)

#5

how about wrapping the

Ex:= Où (= “0” Et InList “Conference”,“Playback”,“Recoding” )

Dominicp :singapore: (BOB member since 2004-12-20)

#6

I think than we need always IF THEN…ELSE
for the reason than I mention above :wink:

Regards
Chris

Maitre B (BOB member since 2004-09-02)

#7

Chris, the WHERE clause with the work around should just work fine. If you like attach your problem report (stating the Business Objects version you are using).

Andreas :de: (BOB member since 2002-06-20)

#8

Hi Andreas,

I have attached my report whith my 3 indicator on the form if then else
My objective is to have on the same row for an account ref :
Datanow Anytime Event Service Amount
xx,xx xx,xx xx,xx xx,xx

I use BO 6.5.

Thanks in advance
Chris
Exemple.rep (172.0 KB)

Maitre B (BOB member since 2004-09-02)

#9

I have succesfully created my report with a “rupture” on my account object and “fold” :smiley:

I would be interesting to know the solution with the where clause :o

Regards
Chris

Maitre B (BOB member since 2004-09-02)