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.
With the WHERE clause (Où in French )
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 recoding and not conference
Second :
I cannot make a formula include the InList condition
Ex:= Où (=0 Et InList ‘Conference’,‘Playback’,Recoding’ )
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).
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