Skip to Content
Former Member
Feb 05, 2018 at 07:50 AM

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.