Skip to Content
avatar image
Former Member

Calculating average of opening and closing stock month wise

Hi Experts,

I need to calculate average of stock month wise in bex designer. Can you pls guide me how can i design my report.

Input will be Fiscal year. Output should be average stock month wise for that fiscal year.

Average stock = (closing stock of previous month last day+closing stock of present month last day)/2

Eg. for April.2017 average stock is (stock on 31.03.2017 + stock on 30.04.2017)/2

Thank you in advance.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 05 at 09:56 AM

    Hi,

    Just an idea.

    For example, you have a fiscal year of 2017.

    How about having a fixed 12 RKF representing the closing stock of December 2016 to November 2017. Then using them, you can already achieve your formula? For the month, you can do a CMOD so that your variable will know what month and year will it get based on the input fiscal year.

    Regards,

    Loed

    Add comment
    10|10000 characters needed characters exceeded