FOX formula - conditional statements (example)

[Former Member]

Hi all,

Can you please provide me few examples for <b>FOX formulas-</b> <b>conditional statements, Loop Construct, and FOX Functions in the SALES PLANNING OR PERSONNEL COST PLANNING.</b> I will appreciate it if you can response ASAP. Thank you.

J.

[Former Member · Accepted solution]

Example 1.

This formula verify if input value (write on index ZRKAMMPCT) is in a correct range of value..

DATA PCT TYPE I.

DATA LOW TYPE I.

DATA HIGH TYPE I.

DATA MCLASSE TYPE ZRHASSCL

DATA CDC TYPE ZRHCOSTCE.

MCLASSE = OBJV().

CDC = OBJV().

PCT = ZRKAMMPCT.

LOW = ATRV(ZRHPRLOW,MCLASSE).

HIGH = ATRV(ZRHPRHIGH,MCLASSE).

IF (PCT < LOW) OR (PCT > HIGH).

MESSAGE E000(ZREM) WITH CDC MCLASSE LOW HIGH.

ENDIF.

Example 2.

In this example I use VARI and VARC function to read Global variable's values.

DATA MESE TYPE 0FISCPER3.

DATA PMESE TYPE 0FISCPER3.

DATA NPER TYPE I.

NPER = VARC('ZRVAPPER').

MESE = VARI('ZRVAPPER',NPER).

DO.

IF NPER = 1.

EXIT.

ENDIF.

PMESE=TMVL(MESE,-1).

DO.

{0AMOUNT,MESE,003} =

{0AMOUNT,MESE,003}+{0AMOUNT,PMESE,003}.

IF PMESE = 001.

EXIT.

ENDIF.

PMESE=TMVL(PMESE,-1).

ENDDO.

NPER = NPER - 1.

MESE=VARI('ZRVAPPER',NPER).

ENDDO.

Regards

Message was edited by: Riccardo Fortunato