Problem with the result line (formula Collision)

[Former Member]

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.

[Former Member]

Take a look at the following thread:

<a href="https://forums.sdn.sap.com/click.jspa?searchID=6542904&messageID=3984947">https://forums.sdn.sap.com/click.jspa?searchID=6542904&messageID=3984947</a>

Hope this helps...

Bob

[Former Member]

Thanks for your post!

As you said the only solution is put the KF in the Cube.

But this solution was very expensive for me. So I used JavaScript to read the result line, make the calculation and write the correct value in the HTML code.

The problem is that I cant plot a chart in BEX using the calculated data. So I'm studying a way to use a JavaScript tool to plot it.

For example:

http://www.gerd-tentler.de/tools/graphs/index.html

Thank you,

Marco.

[Former Member]

Hi Bob

I can't open the thread link, could you please forward to me.

TIA

Haris_Suseno@yahoo.com