cancel
Showing results for 
Search instead for 
Did you mean: 

RE: how do I get the month difference from the input selection

colin_cheong
Contributor
0 Kudos

User is prompt to enter a start and end month for data extraction. There is a need to state the average on 1 of the report column, eg Sales

How do I get the denominator for my Average Sales based on the input month?

Average Sales = Total Sales / ???

Thanks

Bye

Accepted Solutions (0)

Answers (2)

Answers (2)

colin_cheong
Contributor
0 Kudos

I found the sample codes from SAP help.

Thanks for all your assistance

former_member205352
Active Contributor
0 Kudos

Create a formula variable of type customer exit.

Use the user entered values to calculate difference between the two entered months using l_s_range-low and l_s_range-high.

In the formula

Average Sales = Total Sales / <formula variable>

Hope this helps.

colin_cheong
Contributor
0 Kudos

Hi,

I am trying to create a customized routine.

However, I am not sure which component to use.

EXIT_SAPLRSAP_001

EXIT_SAPLRSAP_002

EXIT_SAPLRSAP_003

EXIT_SAPLRSAP_004

Can you show me the way?

Can you provide me with a sample codes for computation of the month differences?

Thanks

former_member205352
Active Contributor
0 Kudos

EXIT_SAPLRRS0_001

Or

Directly edit in program ZXRSRU01 program.

Edited by: Praveen G on Oct 20, 2008 6:20 AM

colin_cheong
Contributor
0 Kudos

Can you provide me with some sample codes?

I am new to BI.

I need to know which structure to read in order to compute the month difference.

Thanks