Skip to Content

Calculating average of opening and closing stock month wise

Feb 05 at 07:50 AM


avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Loed Despuig Feb 05 at 09:56 AM


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.



10 |10000 characters needed characters left characters exceeded