Product: Mapping Manager
Since much of data being passed through Mapping Manager will have the same symbols of math yet not be intended to be used as a math operator the @NUM() function is used as a wrapper for informing Mapping Manager when to begin performing mathematical calculations.
@NUM()
@NUM(TokenCalculation)
TokenCalculation: Combination of Token or Hardcoded value
Operator | Sign |
Add | + |
Subtract | - |
Multiply | * |
Divide | / |
Rules
Should not have spaces between tokens and operator
Only a single math-operation within a @NUM()
Requires nesting @NUM statements to perform multiple calculations
Examples
Add
@NUM([T:Main.Charges.Total of Line Items]+[T:Main.Charges.Other Charges])
Subtract
@NUM([T:Items.Price]-[T:Items.Promotional Allowance])
Multiply
@NUM([T:Items.Quantity]*[T:Items.Price])
Divide
@NUM([T:Items.Quantity]/[T:Items.# Inner Pack])
Nested @NUM()
@NUM([T:Items.Price]*@NUM([T:Items.Quantity]/[T:Items.# Inner Pack]))
rev 10/25/22