Calculation is not working properly

[bsjain]

Hi,

we have three elements
Elements Weight
Actual 1
PY Actual -1
Actual vs PY Actual Actual+PY Actual(Calculated)

In this PY Actul data derived from rule to take Actual data of previous year

problem:

Actual vs PY Actual value is not calculating properly, it only showing Actual value it means rule derived value is not considering in the calculation.
Kindly provide your views

[Michel Zijlema]

I moved the topic from the Enhancements subforum to the TM1 forum as this has nothing to do with enhancements - please post in the appropriate forum.

Looking at the issue this sounds like a feeder issue. Make sure the PY Actual rule is properly fed.

Michel

[bsjain]

Hi,
Thanks for reply,I have used the feeder also but still its not working ,please find below
Rule
['PY_ACTUAL'] =
DB('Cube',ATTRS('xx_Year',!xx_Year, 'Prior'),'ACTUAL',!xx_Month,!xx_Cost_Center,!xx_PnL_Account);

Feeders

['ACTUAL'] => DB('cube',ATTRS('xx_Year',!xx_Year,'Prior'),'PY_ACTUAL',!xx_Month,!xx_Cost_Center,!xx_PnL_Account);

[Michel Zijlema]

Hi,
Thanks for reply,I have used the feeder also but still its not working ,please find below
Rule
['PY_ACTUAL'] =
DB('Cube',ATTRS('xx_Year',!xx_Year, 'Prior'),'ACTUAL',!xx_Month,!xx_Cost_Center,!xx_PnL_Account);

Feeders

['ACTUAL'] => DB('cube',ATTRS('xx_Year',!xx_Year,'Prior'),'PY_ACTUAL',!xx_Month,!xx_Cost_Center,!xx_PnL_Account);

Hi,

Two remarks on your rule/feeder:

The Feeder is not correct: the PY_ACTUAL rule is pulling from prior year, the feeder therefore should feed in the opposite direction - so should feed next year, not prior year.
Try restricting your rule to N level by prefixing the rule with N:.

Michel