Opening & closing stock

[#1]

Hi all,

How to calculate opening and closing stock using following data.

Please find the attachment of input & output excels.

Regards ,

Shweta Singh

[#2]

PFA of excels

[#3]

Hi. Could you please elaborate? how do u wish to calculate closing stock?

[#4]

no logic has been given by client

[#5]

how we can convert month from string format to  num format

[#6]

any help

[jonathandienst]

I think you will need to get more information from your client on how to use these two spreadsheets.

[petter · Accepted solution]

This is how you can do it with a simple Straight Table approach. Create an expression for each column with a Set Expression which select the Year, Month and Data Type that should be retrieved for each column in the chart: (I have attached the sample application)