TM1 Forum

Hi All,

I am trying to copy data from Actual Scenario to RF till the closing period.

From Oct to Dec there is a rolling forecast data which I don’t want to overwrite with ‘0’.

Rule:
SKIPCHECK;

['RF']=N:IF(NUMBR(SUBST(DB('System','Latest Actuals Month','Value'),1,4))=NUMBR(SUBST(!Time,1,4)) &
NUMBR(SUBST(DB('System','Latest Actuals Month','Value'),6,2))>=NUMBR(SUBST(!Time,6,2)),
['Actual'],
STET);

I see the data for Jan - Sep. But, i don't see the data at Q1, Q2, Q3 and Total Year.

Looks to me a feeder issue...but not sure what feeder needs to be used.

Can anyone please help me with the Feeder?

Thanks in Advance.

Appz

Is there any reason you wouldn't just feed ['RF'] => ['Actual'] ? You may get some slight over-feeding if you delay updating the ['last actuals month'], but it shouldn't be significant.

It's also worth noting you can store date strings as numbers in TM1. I do this as a matter of course, as rules involving SUBST and NUMBR are often quite slow. Just remember to offset dates by 21916, as has been covered on this board before if you search.

This would simplify your rule greatly, especially if you use a date lookup cube to grab the serial number of the current date, as I described in this post.

Lazarus wrote:['RF'] => ['Actual']

In the context of OP's circumstances it should really be the other way round: This might cause overfeeding, but as Lazarus said, in a typical case it's not a big concern.

Thanks a lot...QML and Lazarus.

Feeder is working correctly.

Appz