on 09-22-2008 7:36 AM
Hi Friends,
In my reporting scenario i need to populate 2 column values in the output (1.age and 2. Range) for this i have created one calculated KF for Age, in output of the Report client wish to see like the below format
Age Range
25 0-30
31 31-60
55 31-60
How can I achieve this, please suggest me.
Regards,
JR
Clients needs this in the selection screen as Variable ?
If yes then you need to create 3 Aging variables
1. 0 -30
2. 31-60
3. > 55
and give formula for each Aging in the columns for each separately.
If you think this will work then let me know I will tell you the formules you can use to recurr this
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi JR,
You can create the formula key figure with the below formula:
Formula:
( ( AGE <= 30 ) * 1 ) + ( ( ( AGE > 30 ) && ( AGE <= 60 ) ) * 2 ) + ....
This formula will help you to figure out the age of the person within the range.
In the above case, it will return the value '1', if age is between 0 and 30. Or if it is between 31 and 60, it will return 2.
Hope this will help you.
Regards,
Yokesh.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Check the link below.
http://help.sap.com/saphelp_nw04/Helpdata/EN/23/17f13a2f160f28e10000000a114084/content.htm
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
you mean ... if age 25 then ragen 0 - 30? You can try it via JavaScript directly in the report or try it in BW with transformation rules.
Regards, Thomas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
96 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.