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.