CURR (Row 1)
=mandatory in template or in PARAM (FORMS)
=optional in row 1 (REPORTS)
Parameter | Mandatory/Optional | Value (example) | Occurrence in row 1 | Comment | |
---|---|---|---|---|---|
FORMS | REPORT | ||||
CURR | SEK | 1 | In FORM templates, a currency code must be defined in the PARAM sheet or in the template (in column A or row 1). |
CURR is a FORM specific parameter that is mandatory either in column A, row 1, or in PARAM. When updating values in the database, the data rows need to be tagged to a specific currency in order to keep the updated data cells separated and not risk that existing data would be updated with incorrect data. Even though the values that are registered in the form might not be money, a currency code must always be defined.
This parameter can also be used in REPORTS if data from the Bizview data view (in which FORM data is updated) is used in the report. Then, one specific currency may need to be specified in order to get the correct numbers in the report; however, that is only the case if data is registered in several different currencies.
Note: CURR can only be defined in ONE place, either in column A (for each CVAL column), in row 1 (for each DATA row), or in PARAM.
If a template only contains one currency, then it is best to state CURR once in the PARAM sheet. However, CURR can also be stated in row 1 and defined for each DATA row. If a template contains several currencies for different DATA rows, then CURR must be defined in row 1.