Key Figure locking.

[former_member503200]

I am working on a macro using 5 KFu2019s, A,B,C, D, E with 2 steps.

Step1: Some of the cells in A are locked, The calculation is like this, C = A u2013 B, we want locking info need to updated with C.

Step2: E = C+D, the locking information in C, need to be updated in E. I changed the attribute of the KF C to fixed values, I am getting an error u2018 The macro attempted to write an invalid fixed valueu2019 in my 1st step itself. Is it possible to populate fixing logic in KF u2018Eu2019?

We got some conditions check in macro also. I tried with out conditions also, but its not working.

What logic I need to use. Any help is appreciated.

thx

Jeff

[former_member503200]

Thx Ashutosh Chitale,

We want locked cells data in key figure A need to be updated in Key Figure C. Where C is calculated ( A - B).

thx

Jeff

[Former Member]

Hi Jeff,

I am not sure if I have understood your requirement completely. As a first input, I suggest to check if Key figure C is defined as a fixed key figure in info object definition.

Can you please explain this 'The calculation is like this, C = A u2013 B, we want locking info need to updated with C.'?

Warm regds,

Ashutosh