TM1 Forum

When I am summing the element values at leaf level(N), if any of the elements are null it is not summing up. Can anyone help me on this.


['After Adj'] =N:['B4 Hedg'] + ['Prior Adj'];
in some cases ['Prior Adj] is having no values, at that juncture that the result is yeilding null/0. Actually it should yeild the value of ['B4 Hedge'] in the cell ['After Adj']

Any reason you're not using a hierarchy for this instead of rules?

Steve

Just like Steve I'm wondering whether there's anything stopping you from using a consolidated element instead of the sum in the rule.

Are you using SKIPCHECK/FEEDERS? If so, what is the feeder for the rule? Could it be you're feeding from ['Prior Adjustment'] only?
Is the ['Prior Adjustment'] element in itself a rule calculated element? If so, what is the calculation (and feeder) for this element?

Michel

ThanQ Michel, it worked when I have included elements in @ Feeders.

As pointed out by both Steve and Michel you'd be better to do this using a consolidation in the dimension instead of a rule. It's faster, clearer and will apply automatically to any cube that uses the dimension.

Martin

ram3sh wrote:ThanQ Michel, it worked when I have included elements in @ Feeders.

It may work, but rules are considerably less efficient than consolidations. You should always opt for the latter if you have a choice.

{Edit: Martin beat me to it by a minute, but I'll leave this post here for emphasis.}