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 a comment
10|10000 characters needed characters exceeded

### Related questions

• Posted on Feb 05, 2018 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 a comment
10|10000 characters needed characters exceeded