How to define the IF condition in a Report

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

Hi,

Check the link below.

http://help.sap.com/saphelp_nw04/Helpdata/EN/23/17f13a2f160f28e10000000a114084/content.htm

Regards.

[Former Member]

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

[Former Member]

I need to accomplish this task in SAP-BI report.