Skip to Content
0
Former Member
Jan 23, 2007 at 03:28 PM

Hierarchy roll up and sign reversal

24 Views

Hi SDN,

I use a replacement path variable in a calculated key figure which gets the value of the reversal sign attribute for a node. I get the following error message:

==========================================================

Variable ZPSIGN2 is not allowed in a calculated key figure

Diagnosis

The variable ZPSIGN2 must be replaced with a hierarchy attribute. This function is not supported for calculated key figures.

System response

Procedure

Define a formula analogous to the calculated key figure.

===========================================================

Can anyone suggest a work around it? I need to a calculated key figure weighted on the reversal sign to correctly roll up in the hierarchy.

Thanks.

Saf.

I always award points.