Forward Values along periods with null value

[orital81]

Hi All

I have a forecast for Inventory values

But, the values appear in the source table only

if there was any expected transaction.

I would like to to the following:

In case a month has no value, forward the values from last period where there was a value (Total Forecast is 1 year)

For example, here is my current table:

Here is how I would like it to be:

..... Continue till 2014-05

Attached the QVW file.

Thanks for your help!

[orital81]

I would appreciate any suggestion

Thanks.

[sushil353]

Hi Ori,

If you check your dataset .. then you can analize that the 2013-06 month is not associated with the current selections. if it is associated with the dataset and the value is null then we can assign it the previous month value.

[orital81]

Hi Sushil

This is one of the issues I would like to consult.

How can I assosiate the calendar to periods where there are no records.

I know that interval match can be used for this, but I prefer to use a different method.

[sushil353]

i think you should go for master calender.

[orital81]

There is a master calendar. It's joined to the table.

[Gysbert_Wassenaar · Accepted solution]

I think you need to create the 'missing' values in the script. This blog post may help you do that.

[orital81]

Thanks Gysbert, that's exactly what I was looking for.