This screen demonstrates the use of the "Mathematical calculation of a field" option and how it may be used to produce a "virtual" field's value by performing a mathematical calculation.
Calculate the Gross sales price of a transaction by multiplying the Net sales price by the Current sales tax rate and adding the result to the Gross sales price:
DC@P201607 Mathematical calculation of a field
File: SALTRN Sales Transaction file
Virtual field: GRSPRC Gross sales price
Derive "virtual" field on input from file . . : YES YES, NO
C A L C U L A T I O N S P E C I F I C A T I O N
Value 1 Operation Value 2 Result
_________ S 0_________ GRSPRC___
NETPRC___ / 100_______ *WORKNET01
WORKNET01 * SALTAX____ *WORKTAX01
NETPRC___ + *WORKTAX01 GRSPRC___
_________ _ __________ _________ +
Fnn=Help Fnn=Exit Fnn=Cancel Fnn=Messages Fnn=Change Fnn=Delete
|
|---|