Last Inventory Values Date Chart

[Anonymous]

Hey Clickers

Im currently struggling a bit to show the correct values in a bar chart. The Chart is actaully showing the stock history, which were runing  correct, as long we processed the stock update just once a month. Since September we have started as a trial to update the figures once a week and store this value on the database. Befor it was quite easy as i could just use the sum(), now i tried to get the last figures of a period by using maxstring() function, but this function is just showing the overall last value and is therefore not showing the history anylonger. Perhaps i did it wrong.

Sample how the stock values gets accummulated for september

Stockupdate Files (just a total)

How should i modify the expression

sum(#InventoryOnHand_EUR)

so that i get just the last value of a specific Period (Jul-2015, Aug-2015)? The Barchart is just using Month-Year as Dimention (later also Week-Year) and the sum of the inventory value as expression

Can somebody help me out on this

Many thanks

[Anonymous]

just got an error on my chart

And really dont know how to solve this...

If i select a item which currently has stock zero, the whole month will not be displayed, as there is no value. The problem is that we do not store items in the database with stock zero, thats mean no stock, no record. As conclusion the firstsorted value, will not display the month september...

Can you help on this, any idea how to manage?