on 05-21-2017 11:11 AM
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.
Hi,
Have you found answer to this problem, even we are getting issue with Sum_CALC() funcation. it is not returning anything.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
15 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.