Skip to Content
0
Former Member
Nov 07, 2007 at 03:05 PM

IP - Key Figure value in fox formula's condition

12 Views

Hi experts,

I want to fill a characteristic according to the value of a key figure. I have thought to make it with a formula fox and then to verify the possible cases (01,02,03 or 04) for the key figure.

I have tried with:

IF {key figure, CHAR, #} = 01.

{key figure, CHAR, new value} = {key figure, CHAR, #}.

ELSE.

IF {key figure, CHAR, #} = 02.

{key figure, CHAR, new value} = {key figure, CHAR, #}.

...........

but it is not correct, so I have tried with the following:

IF {01, CHAR, #}.

{01, CHAR, new value} = {01, CHAR, #}.

ELSE.

IF {02, CHAR, #}.

{02, CHAR, new value} = {02, CHAR, #}.

...........

and it is not correct.

Any idea??

Thanks in advance.