Mathematical Examples

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