SCALE (Row 1)
= optional in row 1
Parameter | Mandatory/Optional | Value (example) | Occurrence in row 1 | Comment | |
|---|---|---|---|---|---|
FORMS | REPORT | ||||
SCALE | -1000 | 1 | Values will be recalculated with the defined SCALE. Define a scale factor for each DATA row (FORMS) or each report row. Can be defined in column A, row 1 OR in PARAM. If no SCALE is defined in column A, row 1, or in PARAM, then it is set to 1 by default. The value needs to be a valid number. | ||
SCALE is a common parameter which can be used both for FORMS and REPORTS. The parameter is used to re-calculate the values returned from the database, or values updated to the database. It can be used either in PARAM, row 1, and/or in column A in the template. If no value is defined for SCALE, then the default value 1 will be used.
For example, a SCALE value of -1000 in a form is used to multiply the value when updating them to the database, which means that the end-user can enter values signed reversed in thousands. In certain cases, different SCALE values need to be used for different columns or different rows in a document. If so, then SCALE should be used in column A or row 1 in the template. If the same SCALE applies to all columns and rows in the template then it is better to define the parameter in PARAM.
Note: If SCALE factors are defined both in PARAM, row 1, and/or column A, then Bizview will multiply each SCALE to each cell value. For example, if SCALE in PARAM is set to -1000 and SCALE is also defined in column A as -0,001, then the cell values in the column will be calculated as cell value*-1000*-0,001.
Values will be multiplied with the SCALE factor(s) when updating values in the database and when fetching values to the form/report then values will be divided by the SCALE factor(s).
Note: SCALE in row 1 should be defined with SOURCE=BV in the template