Question:
hi gurus,
i want the result of an calculated keyfigure in another keyfigure
if i use Result fn. in the new key figure it is not populating correct values
can u guys please help me out.
1. CKF1 is calculated using a result column of another keyfigure and another keyfigure.
2. CKF2 i only want the result of CKF1.
thanks in advance
sathish [/img]
Answer:
Not sure if i am missing something here, just create a formula of the result of the CKF1
SUMCT 'CKF1'
Not sure exactly what result you want to see, play with the SUMCT, SUMGT, SUMRT options one of them should give you what you want.
cheers
Answer:
already played with result functions
My query will have two result rows
one for each item level & another overall result.
if i remove item level reult, then i am getting the overall result populating in the new KF.
But i want the item level result in the new KF
o/p :
WTD WTD1
1.0000 0.0003
1.0000 0.0003 (result row )
01.0000 0.0177
62.0000 0.0177
62.0000 0.0177 (result row )
14.0000 0.0194
14.0000 0.0194 (result row )
47,161.0130 4,164.9838 ( overall result )
o/p expected :
WTD WTD1
1.0000 1.0000
1.0000 1.0000 (result row )
01.0000 63.0000
62.0000 63.0000
63.0000 63.0000 (result row )
14.0000 14.0000
14.0000 14.0000 (result row )
78.0000 78.0000 ( overall result )
Answer:
gurus any suggestions....
how the result of an Calculated keyfigure will behave in other calculated key figure
Answer:
I am having what may be the same problem - the SUMCT function does NOT seem to work if I'm trying to use the Results from a CKF column in another CKF.
To illustrate:
Characteristics are in rows.
Columns:
Col1 is a regular KF, from the infocube
Col2 is another regular KF, from the infocube
Col3 is a formula = COUNT(Col1)
Col4 is another formula, attempting to use SUMCT from both Col2 & Col3, putting the formula result in every cell in Col4
Specifically, Column 4 formula:
SUMCT Col2 / SUMCT Col3
What I'm getting is SUMCT Col2 / Col3 individual values.
The SUMCT function on Col3 is ignored!
I've tried this with various formulas in Col3, not just counts, and in all cases the result of Col3 is ignored by the SUMCT function in Col4 (the individual row values for Col 3 are used instead).
Is it not possible to use the SUMCT function based on the results of another formula?
The SAP support site and 'How To' papers do not mention any such limitation.
Our BW version is 3.5 support pack 15.
Any ideas out there on how to make such a formula work?
Answer:
hello
I'm a bit surprised at your results. I did a quick test, with a query like this:
col1 = KF from cube
col2 = KF from cube
col3 = f(col1)
col4 = g(col2)
col5 = sumct col1 / sumct col2
and the results of col5 are OK...
are you sure your issues are not related to your KF having "complex" agregation options ?
Yann
Answer:
Thanks for the reply Yann.
The SUMCT functions works just fine for me also, as long as I am not applying the SUMCT function to the result of another formula.
In your example, if I define col5 as
col5 = sumct col1 / sumct col4
I do not get the correct result.
The individual values from col4 are used instead of the subtotals and total from col4.
The SUMCT function works just fine in determining and using the subtotals and total from col1.
Does it also work this way for you?