Using the Field’s Properties Window
You enter calculations for variable fields in the Calculation area of the field’s Properties window.
Here is a sample calculation:
Calculation |
Return (@("Prem Basis1") * @("Prem/Ops Rate1")/100) |
Result |
Takes the value of a variable field named PremBasis1 multiplies it by the value of a variable field named Prem/Ops Rate1, divides the product by 100 and places the result in the current variable field. |
Keep the following formatting points in mind as you enter your calculation in the Properties window:
- You can enter up to 512 bytes (or characters) of information for a calculation. For larger scripts, create them as external files (*.DAL).
- The calculation language is not case sensitive.
- Place comments only on the last line of a calculation. Begin each comment line with asterisks.
- Place a semicolon (;) at the end of each calculation.
- If you have multiple calculations, separate the calculations with semicolons, as shown here:
If flag = "y" then return (sum("field")); else return ("exclude"); end;
- Extra space and tab characters within script statements are considered white space. White space may appear anywhere in the script to improve readability, but is ignored during the evaluation of the script. Blank lines within external script files are also considered white space.
- Field types (i.e. Alphabetic, Alphanumeric, etc.) cannot hold more than 1024 characters. DAL variables cannot hold more than 1024 characters. DAL cannot send more than 1024 characters to a Multiline text (MLT) field. Although a DAL variable can return up to 1024 characters, the defined length may truncate what is returned.
Note | All space and tab characters inside a string constant are not considered white space, but rather part of the string. |