I have a issue but not to sure where to start…
I have created a Webi report. One of the columns “Department” has been derived using a IF statement.
I then have created a Break on the ‘Department’
So the report looks like this
Department Employee Hours Amount
Accounts
Bob 2 100
Jon 2 200
IT
Alan 1 50
James 3 150
But when I try to create subtotals I get the whole amounts on each lines as shown below. Columns 2 & 3
Department Employee Hours Amount
Accounts
Bob 2 100
Jon 2 200
8 500
IT
Alan 1 50
James 3 150
8 500
As you can see the report seems to gives the sum of the total column at each section. (eg for amount it add up 100+200+50+150)=500.
The amount total of 8 & 500 appears as a section total which is incorrect. For accounts I expect 4 and 300 and for IT I would expect 4 and 200 ( these are columns 2 & 3 respectively
Your urgently
many thanks
Sam
Sims786 (BOB member since 2006-04-04)
(BOB member since 2009-08-03)