Following is an example of a mathematical calculation virtual column.
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:
Factor1 | operator | Factor2 | Result |
|---|---|---|---|
S | O | GRSPRC | |
NETPRC | / | 100 | *WORKNET01 |
*WORKNET01 | * | SALTAX | *WORKTAX01 |
NETPRC | + | *WORKTAX01 | GRSPRC |