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

Sales per Working Days

I have a requirement to report the average sales per number of working days in the period. I have created a function module that can access the factory calendar and compute the number of working days in a given year/month and have populated a key figure on each record with the number of work days in the period the transaction took place in.

When I display the number of working days by year/period in a report of course it adds up the days from each transaction and gives false numbers. This seems like it should be a no brainer, but I can't find an easy solution. Can anyone help me with displaying the correct number?

Thanks in advance.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 06, 2005 at 07:43 PM

    Hi

    Try this logic:

    create an avarage Working Days KF1.

    its the working days / Rec Count.

    This KF if you group on CalYearMonth will show the sum

    of the numbers for that motnh.

    then if you want you can take KF1 and create another KF,

    lets say KF2 that is total Sales / KF1.

    I hope it helps.

    Reg's

    Edan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 07, 2005 at 03:50 AM

    Hi,

    Why do not you use a formula variable with customer exit as processing.

    Here , you will use same function module to access the factory calendar and will compute the number of working days in a given year/month(user entry variable).

    With rgds,

    Anil Kumar Sharma .P

    Add a comment
    10|10000 characters needed characters exceeded

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.