This function is used to carry out allocations of values to a variable depending on the value of two indexes or axes: the X axis (abscissa) and the Y axis (ordinate).

Prerequisite

SEEREFERTTO Refer to documentation Implementation

Screen management

 

Entry screen

Header entry

Calculator and title : This is the name of the calculator over a maximum of 8 characters and its title defined over a maximum of 30 characters.

Blocking not found : This setup is used, if it is ticked, to interrupt the scenario if the value in the grid from the X & Y coordinates is not found to correspond with the transferred setups. It is then necessary to correct it in the Configuration questions window.

Abscissa/ordinate result format : It is necessary to specify the numeric, alphanumeric, or date format of the X and Y-axes, as well as the class used It is also necessary to indicate whether to use value ranges for the X and or Y axes in the description of the cross table that is referenced.

X axis/ Y axis / result title: It is possible to personalize the title of the X-axis, Y-axis and result columns in the grid, this is to facilitate the reading of the calculator grid.

X-axis and Y axis grid : It is necessary to enter for each X-axis/Y-axis cross-reference, the result to be used in the scenario. This table must be entered in ascending values order and for the same X-axis value in ascending order of the Y-axis value. When entering numeric Y-axis values, the system suggests the next value according to the value at the previous step.

Block number 1

Double entry tables (field ABQNUM)

Build the array code.
An array is a grid matching any value to a bracket of reference values.





field ABQAXX
Block not found (field RESFLG)

To be ticked if, in the event of a negative search, the scenario should be interrupted.

In this case the variable will be initialized according to its type :

Zero if numerical.

Empty if alphanumerical.

0/0/0 if date.

X-value

Description (field ABSAXX)
Range of values (field ABSCOD)
Format (field ABQTYP)

Choose the format for the ranges of values
- Alphanumerical
- Numerical
- Date
The format can only be modified if the table is empty.


.
Character (field ABQCHA)

Choose:
- Capital letters for automatic conversion in capital letters.
- Lowercase letters for automatic conversion in lowercase letters.
- Capital and lowercase letters to enter without conversion.

Y-value

Description (field ORDAXX)
Range of values (field ORDCOD)
Format (field ABQTYPY)

Choose the format for the ranges of values
- Alphanumerical
- Numerical
- Date
The format can only be modified if the table is empty.


.
Character (field ABQCHAY)

Choose:
- Capital letters for automatic conversion in capital letters.
- Lowercase letters for automatic conversion in lowercase letters.
- Capital and lowercase letters to enter without conversion.

Result

Description (field RESAXX)
Format (field RESTYP)

Choose the format for the ranges of values
- Alphanumerical
- Numerical
- Date
The format can only be modified if the table is empty.
Character (field RESCHA)

Choose:
- Capital letters for automatic conversion in capital letters.
- Lowercase letters for automatic conversion in lowercase letters.
- Capital and lowercase letters to enter without conversion.

Grid

field STRVAL

Enter the start value (excluded value) conforming to the predefined format.
field ENDVAL
field STRVALY

Enter the end value (included value) conforming to the predefined format.
field ENDVALY
field RESVAL

Enter the resulting value according to the predefined resulting format.

Reports

By default, the following reports are associated with this function :

  PRTSCR : Screen print

This can be changed using a different setup.

Copy

This button is used to recopy a two dimension calculation table to another folder.

Error messages

The only error messages are the generic ones.

Tables used

SEEREFERTTO Refer to documentation Implementation