Skip to Content
0

SUM_CALC function

May 21, 2017 at 10:11 AM

69

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Jeet Kumar 5 days ago
0

Hi,

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

Share
10 |10000 characters needed characters left characters exceeded