Inventory As on Date - Calculation help

[#1]

Hi All,

I have a requirement from my management asking for a daily inventory of the stock available.

I have attached the file with table structure, expected output and calculation rules for that.

Kindly help me in getting the desired result and it is urgent. Thank you.

[avastani]

2 ways to do this. in script using the Developer 2 example or in the chart using the ABOVE() function to compute inventory.

ABOVE only works in a straight table. If PIVOT then use LEFT()

[#3]

Thanks for the sugession amirvas.

However I believe that I might not have given you clear requirement.

Let me clarify you once again as below.

I have a table with daily products entered.

I have attached a new file seperated with Table and Output sheet tabs.

When I look at the inventory on a daily basis, I would like to get the data calculated on a As on Date basis as below.

Eg: For As on Date 1/1/2012 - 4 products

      For As on Date 2/1/2012 - 6 products (as 2 products are newly added on 2nd and 2 are already calculated for 1st so we should not included already calculated in previous dates)

      For As on Date 3/1/2012 - 8 products (as 2 products are newly added on 3rd and 3 are already calculated on 1st, 1 is calculated on 2nd, so it should not calculated already calculated products previously.)

Like this it should calculate the data till whereever the data is stored into database.

Suppose when I look at the data as on 2/1/2012 then data should be as follows

1/12012 - 4; 2/1/2012 - 6

Hope u understand this and provide the output.

[#4]

Hi.

I have exactly the same issue. Did you find a solution ?