cancel
Showing results for 
Search instead for 
Did you mean: 

SUM_CALC function

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member332160
Participant
0 Kudos

Hi,

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