Need logic help to calculate Stock Value based on AvgMovingPrice.

[lalitkgehlot89]

Hi,

In current Scenario I want to calculate Stock Value which is based on StockQty and MovingAveragePrice.

For Example.
I want to see Stock Qty and Stock Value of MaterialNo. (N350100000002) on Date 15-01-2019.

Logic for Stock Qty ----------- Sum(StockQty) where PostingDate <= 15-01-2019
Logic For Stock Value ------------ Sum(StockQty) where PostingDate <= 15-01-2019 * Material MovingAveragePrice in Jan2019

Result----------
Stock Qty---------------- 8137
Stock Value-------------- 8137 * 31.81 =258838.97

Please help me out to write the logic either on backend or frontend.

Thanks,

Lalit Kumar

[prabir_c · Accepted solution]

Hi Lalit,

I have created a variable for Posting date and use that under chart Expression.

Please check attached.