Initializing a key figure is not working properly in the planning book on the first change

[Former Member]

Anyone -

We are currently having an issue where I need to do a calculate a Total based on if a key figure is initial or not.  If the key figure is initial, then the calculation is a SUM of a few other key figures.  If it is not initial, then

The macro logic should be very straight forward:

IF

check to see if KFA is initial

IS_INITIAL(

Row: Key Figure A (From X PWW/YYYY)

)

= 1

Row Total =

SUM(

Row KF B

Row KF C

)

ELSE

Row Total =

Row Key Figure A

ENDIF

The problem I am having is that when the following scenario occurs:

1. I open up the planning book

2. A value already exists in Key Figure A, so Row Total already equals Key Figure A

3. I wipe out the value in Key Figure A.

4. Row Total is blank.

Based on the logic in the macro, when Key Figure A is wiped out, then Total should equal the SUM of KF B and KF C, but this is not happening when I first clear out the KF A.

If I re-enter a value in KF A, then clear it out again, the macro logic works perfectly.  There is only an issue with the very first clearing of the key figures.

Any suggestions??

[former_member187488]

Hi, please apply note 1877871 and regenerate your macro.

[former_member407655]

Hi Luis,

Have you checked if you have mistake in the SUM statement?

I suggest you try 2 options:

1) Change to:

SUM(

Row KF B ;

Row KF C

)

----note space+semicolon

2) just type

Row KF B +

Row KF C

-------instead of using SUM

I hope this will help

Regards

[Former Member]

Its not the SUM that is the issue.

The calculation works when I re-enter the value and remove it again.  The issue only occurs when I first wipe out the value.