Skip to Content
author's profile photo Former Member
Former Member

Calculation for Estimate in Bex

Hi gurus,

We have a reporting req wherein Last estimate for sales quantity need to be calculated.In this we need to calculate Sales quantity for Value type=20(Value type 20 signifies planned data) and aggregated for number of periods that user enters using a variable. Say user enters 4 in that variable.then my Last estimate sud calculate sales quantity for value type=20 aggregated for january,feb,march,and april.

Can any one guide me how achive it at query level??

Thanks.

Deepika

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jun 17, 2008 at 06:59 AM

    Hi,

    I guess you can try the foll approach and see if it works out:

    1) i hope there is month stored in the backend for the records. So you need to create a varible type customer exit for the month and it should be not ready for input. select range optin too.

    2) Now in your selection screen you would have a box to slection the number.

    3) now for the month variable write an exit at i step = 2 to populate months depending on the input of number. Say the user enters number 4. Then in your routine you will have a case where it will go fro 4 and take jan to aprl in the month selection automatically.

    4) now in your query create a restricted KF ann inlcude sales quantity in it and restrict it with value type = 20.

    Used this RKF in your report and i guess it should work perfectly for ya.

    Regds,

    Shashank

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Thanks Joke.Sounds gud n easy solution.

      there is slight change in my req.now say if user has entered 4 then i need sales qty for first 4 months(jan-aprl) restricted for value type 10 and then sale qty for value type=20 for rest of teh months.I hav set the variable filter on posting period.now how can i segregate the diff months?

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.