Please help me..

酥糖公子

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

hsszjw

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

kbswangyang

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

str8899

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

hb522422

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.}