Hi, I've the following problem. I want to see the stock day by day of my products, but i do not have historical data. I've a table where I've the current stock and another table with the sellings. The selling table have 2 fields StockFrom and SellDay. StockFrom is even the key field to connecto the selling table with the current stock.
So now I need to find out the stock at a give day; The formula for every day is Current stock with StockFrom<Min([given date]) + Current Stock with StockFrom=[given date] + selling with StockFrom=[given date] - selling with SellDay=[given date].
Now.. everything quite easy if you use a Data Island and IFs... but extremly slow in my situation, so I decided to use StockFrom as main date. so... evrything easy... until the SellDay = [given date] I was thinking to use something like
but I can't handle it... Does someone have an idea of how could it be done?
yeas I tried, but in that way i have for every record the sum of the All SellDay.
ie: StockFrom = '01/01/2012' [...] '10/01/2012' At the DimensionValue '02/01/2012' I would like Only the sell of the '02/01/2012', including the SellDay = P(StockFrom) consider mi all the SellDay in the period and the values is the same for every day
I was thinking to join it with StockFrom something else. Anyway, soon I'll get a look to your example and I'll let you know. I supposed it should be something like if want to see something like "complete date with year" - Products sold in date - Product sold in the same date of the previous year
but i'm getting lost in it
Anyway, now i'll take you file, if i'll have some problems i'll upload mine k you
Remove the TOTAL from the Count() expression in the chart on the right. As specified, TOTAL will return the same values for all the values in the dimension. Are those the right values without the TOTAL? In the script, there are only two autogenerated tables with dates, but not the rest of the data.