Skip to Content
0
Former Member
Feb 06, 2009 at 03:08 PM

BEX - Wrong sum calculation from formula key figure

51 Views

Hi,

I have problem with sum row in my report.

I have one column (4) with is depends on the formula

IF 3 <> 0

THEN 3

ELSE 1

It means if exist value for ACT(3) the column 4 will be field with ACT(3) in another case with PLAN(2) value.

This column(4) is used in another column (5) in formula as a 4/1.

I have problem with summary result of column 5. See example.

1 2 3 4 5

CUSTOMER QNT PLAN ACT PL/ACT PER UNIT

( IF ) ( 4/1)

A 10 100 150 150 15

B 10 300 0 200 30

-


SUM from BEX 20 400 150 150 15 ( 150 / 10 )

I NEED SUM 20 400 150 350 17,5 (350 / 20)

If I set up for key.f. PL/ACT properties "Calculate Result As" to Summation I received

A 10 100 150 150 15

B 10 300 200 30

-


SUM from BEX 20 400 150 350 15

If I set up for key.f. PL/ACT properties "Calculate Result As" to Summation

and for KF "PER UNIT" "Calculate Result As" to "Average of All values" I received

A 10 100 150 150 15

B 10 300 200 30

-


SUM from BEX 20 400 150 350 22,5 ( (15+30)/2 )

Please can anybody help me ?

Thank a lot

Tom