Question:
Hi All
I am having problem with Bex Analyzer formula builder.
I have following output
Col1 Col2 Col3
12 456 Col2/Total of Col1
55 44 Col2/Total of Col1
Total 67 500
It is impossible to use the formula builder to get it to use the 'Total' value in the formula.
Has anyone encountered this situation or do you have a suggestion I can try ?
Many thanks, Zapp
Answer:
zapp,
use the following formula
'Col2' / SUMCT 'Col1'
Here SUMCT represents the data function Result.
You will get the desired result
Cheers
Anu
Answer:
Thanks Anu
In the BEx Formula tool bar, theere are only 7 Data Functions and SUMCT is not one of them.
The system does not allow you to type in the SUMCT, so my questions :-
1. Where does this data fucntion actually live ?
2. How do you type this into the formula ?
Thanks, Zapp
Answer:
[i]Thanks Anu
In the BEx Formula tool bar, theere are only 7 Data Functions and SUMCT is not one of them.
The system does not allow you to type in the SUMCT, so my questions :-
1. Where does this data fucntion actually live ?
2. How do you type this into the formula ? [/i]
hi zapp,
1)SUMCT is nothing byt Percentage Share of Result in the data fucntion i.e., %CT.
2) Type as %CT for SUMCT
lnv
Answer:
There is only %A in the list of formulas. No %CT (ie. percentage of the totals.
%A does not help in our case: Like, % of sales order by a customer for a particular period, by delivery priority, does not give the percentage for the total orders in that period, but only for the total ordered by that customer.
_________________
Keep smiling
Answer:
Hello zapp:
I believe that Anu is correct. You should use SUMCT which is located in the 'Data functions' folder when you create your formula.
Under the 'Data functions' folder, I see 10 functions, not 7:
COUNT
DATE
DELTA
NDIV0
NODIM
NOERR
SUMCT
SUMGT
SUMRT
TIME
Then, the formula is:
'Col2' %A SUMCT 'Col1'
where %A = Percentage share - under the 'Percentage functions' folder
Answer:
I can see only seven (7) in 3.0B (FEP 15):
COUNT
DATE
DELTA
NDIV0
NODIM
NOERR
TIME
Where do SUMCT, SUMRT and SUMGT come from? Should I take it up with SAP or is there a front-end patch that I need to apply (FEP)?
_________________
Keep smiling
Answer:
Hi,
U might be using 3.0B version.
To get SUMCT in 3.0B , create a structure in the Query Designer in the Coulmns->Create a Formula-> U can see the SUMCT in the DataFunctions Now.
Hope this helps ...
lnv
Answer:
Thanks Inv,
Saw it now! Having left it all to the power users, lost touch with the query designer functions! However, I did notice one thing. When I open the query designer directly, I see that it is Version 3.0B patch 15 3020.15. 560, but when I open BEx, it shoes Version 3.0B Patch 15, 3020.15.653.
Curious...
_________________
Keep smiling