Skip to Content
0
Former Member
Nov 07, 2007 at 01:23 PM

Problem with the result line (formula Collision)

15 Views

Hi Gurus,

1)

I'm having problem with the result line in a query (BW 3.5).

My Table is shown below:

........A.....B....C=A*B..D=C

........2.....3....6.......6

........3.....4...12......12

GLOBAL..5.....7..35....35

TOTAL...5.....7...18......18

C column is a Calculated Key Figure. It multiplies A and B column.

I need that the result line for C is 18, not 35 (5*7).

2)

So I tried to use Formula and set the Formula Collision. It doesnt worked.

3)

So I tried to set the "Calculated Result As..." with the CKF. It worked,

but others columns that uses this result picks the old value (35). And I need the

new value (18). Maybe there is an option to pick the new value.

Before tentative 3:

........A.....B....C=A*B..D=C

........2.....3....6.......6

........3.....4...12......12

GLOBAL..5.....7..35....35

After:

........A.....B....C=A*B..D=C

........2.....3....6.......6

........3.....4...12......12

GLOBAL..5.....7..18....35

4) I tried to use SUMCT, SUMGT and SUMRT. It doesnt worked.

Please look into this issue and let me asap if there is any solution for this.

Thanks,

Marco.