AMT Datasouth Fastmark M1 Guia do Utilizador descarregar pdf (Página 283)

100

101

Formula Data Source

Mathematically adding Two Fields Together

1. In the list of Fields, click the name of the first field you wish to include in the formula.

Note: The field name is displayed in the formula edit box.

2. In the list of Operations, click the plus button (+). (It is displayed in the text box, following the

name of the first field.)

3. Return to the list of Fields and click the next field that you wish to include in the formula.

You can use point-and-click methods to create virtually any combination of fields and calculation for a

formula.

Note: Loftware Label Manager does not require you to use point-and-click techniques to create formulas. If you

wish, type your formulas directly into the text box using regular keystrokes.

Formula Examples

The following table provides four examples of Loftware Label Manager’s Formula Assistant capabilities:

Operation Procedure Example

Combine

text from

two or more

fields

Select each field by name and separate field names with the Combine

operator (&).

FirstName & " " & LastName

Perform

basic

mathematic

al functions

Select each field by name, separated by functions using values from

the appropriate mathematical symbol selected fields. (*, -,+, /). Use

parenthesis to override normal math precedence.

(GrossWeight - TareWeight)

/ PieceWeight

Copy data

from

another

field

Enter the field name of the field you want to copy from in the

formula.

Copy from the PackType

field. Example: PackType

Copy part of

another

field

Use the LEFT(), MID() or RIGHT() string functions.

LEFT (Description, 10) =

Copy from the first 10

characters of the Description

field.

The Formula Assistant’s Operators and Functions

Loftware Label Manager uses standard spreadsheet-type operators and string functions.

Mathematical Operators

Operators Description

* Multiplies the values of two selected fields.

/ Divides one field by another.

Loftware LabelManager Version 10.1.1 User's Guide

283

1 2 ... 278 279 280 281 282 283 284 285 286 287 288 ... 531 532

Comentários a estes Manuais

Sem comentários

AMT Datasouth Fastmark M1 Guia do Utilizador Página 283

Comentários a estes Manuais