Question:
Hi,
I am on BW 2.0 B.
I have a condition defined in my query (let say on flag) . If I look at the most detailed level I see the condition filters the rows i don't need, but still the values are included in the result , so the result is to high. Also when i look at a less detailed level the excluded lines are included in the subtotals.
It seems to mee the condition is applied after the calculation of the totals en subtotals is
done ?
Without condition
day 1 Title Businesspartner flag delivery
subtotal 1 X 0 10
subtotal 1 X 1 90
With condition flag = 1
day 1 Title Businesspartner flag delivery
subtotal 1 X 1 100
(when I sum them myself in exel I got 90)
OR
day 1 Title flag delivery
row 1 X 1 100
How to calculate the subtotals or totals or aggregations after the condition.
Thanks,
Sergeke
Answer:
When I had this problem on BW2.1C I changed the key figure properties in the query. In the query right click on the key figures, amend the Calcualtions to Summation. This will then only add up the items that are shown when the condition is applied.
Hope that this works for 2.0B.
Answer:
Hi Ross,
Thanks, this works fine for the resul lines when I look at the lowest level. But when i remove a charateristic to look at a higher level got wrong values.
OK
char_1 char_2 key
X 1 5
X 2 3
X 3 4
Result 12
NOK
char_1 key
X 517
Result 517
Grrrrr !!!!!!
Sergeke
Answer:
The only other suggested setting that I can think of is in the condition definition. On the cell restrictions tab change the default operator to All.