Skip to Content
avatar image
Former Member

SUM_CALC function

Dear Experts,

Key Figure 1 = 100 total

Key Figure 1 Member 1 = 40

Key Figure 1 Member 2 = 60

Key Figure 2, Member 1 (details all) = 10

Key Figure 2, Member 2 (Details al) = 30

In Key Figure 3 I expect followed results

Key Figure 3, Member 1 = KF2 Member 1 x KF1 Total = 10 x 100

Key Figure 3, Member 2 = 30 x 100 likewise

I tried using SUM_CALC ( 'KF1' ) hoping 40 + 60 makes 100 but nothing gets updated in KF3.

Macros in the Macro Book

Macro Compute KF3 (Details Only)

Step1. Drill Down Internal if Aggtd by Char1 : ( 1 Iterations :Y 2017;Y 2017 )
IF
What is the Agg Level ?
AGG_LEVEL( 'CHAR1' ) = 1
Drill Down Internally
DRILL_DOWN( 'CHAR1' ; 'INTERNAL' )
ENDIF

Step2 : ( 5 Iterations :Y 2017;Y 2021 )
KF3 ( Frm Y 2017 ) =
SUM_CALC (' KF1' ) ( Frm Y 2017 )
*
KF2 ( Frm Y 2017 )

____

If this helps to mention, CHAR1 is a Navigational Attribute.

Syntax is technical ok.

Nothing gets updated in KF3 as I expect.

What I am doing wrong?

I also tried separating the steps as separate Macros and run it as collective.. SAP Advisory for DRILL_DOWN functions but still same. No value updated in KF3.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 15 at 12:32 PM

    Hi,

    Have you found answer to this problem, even we are getting issue with Sum_CALC() funcation. it is not returning anything.

    Add comment
    10|10000 characters needed characters exceeded