SCALE
= optional in PARAM sheet
Parameter (col A in PARAM) | Mandatory/Optional | Value in col C (example) | Value in col D (example) | Value in col E (example) | Occurrence in PARAM sheet | Comment | |
|---|---|---|---|---|---|---|---|
FORMS | REPORT | ||||||
SCALE | -1000 | N/A | N/A | x number of times if sections exists in template. | If parameter or parameter value is missing, then the default value is 1. The value needs to be a valid number. Can be used in PARAM and/or in template. | ||
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, and/or in column A and row 1 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 in row 1 in the template.
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 retrieving values to the form/report then values will be divided by the SCALE factor(s).
Access SCALE factors in the Template Design right panel by selecting Parameters > Data Dimensions > Scale Factor:
In the Scale factor field enter a valid number (1, -1, 1000,-1000), or a formula to retrieve the scale factor from for example a selection pane. If you click the tag icon to the right in the field, you can select a CF_GETPANEVALUE formula to get the scale factor from the selection pane.
If you want revenues to be shown positive and costs to be shown negative, then you should use -1 or -1000 as scale factor depending on if you want the numbers to be shown as is, or in thousands. If the template contains several sections, you can add specific scale factors for each section or define one for all sections. If you leave the Section drop-down empty, the Scale Factor will apply for all sections.