DMath

DMATH Functions Functions that work on numeric fields and create fields with decimal precision Purpose Use DMATH functions to: Perform efficient mathematical manipulations on numeric data Perform floating point math functions Return ...

DMath: A Creates a decimal copy of Field A Purpose Use this function to: Turn an integer field into a decimal Create a copy of an existing numeric field Create a filtered copy of an existing field Create a copy of an existing field whe...

DMath: A/B Divides numeric input A by numeric input B Purpose Use this function to: Create ratios Calculate percentages Scale data Return Value Example Return Value: X*.XXXXXX....-X*.XXXXX e.g. 21.000000, 98754654.123456, -5.0...

DMath: A+B Adds the value of Input A to the value of Input B Purpose Use this function to: Sum numeric data Add values from numeric columns together Increment a column by a fixed value Return Value Example Return Value: X*.XXXX...

DMath: A-B Subtracts the value of B from the value of A Purpose Use this function to: Calculate the difference between subtrahend and minuend. Subtract the value of one field from another Decrement a column by a fixed value Return V...

DMath: A*B Multiplies A by B Purpose Use this function to: Calculate the product of factors A and B Multiple one field by another Scale data Return Value Example Return Value: X*.XXXXXX....-X*.XXXXX e.g. 21.000000, 98754654.12...

DMath: A*B*C Multiplies A, B and C together Purpose Use this function to: Calculate the product of factors A, B and C Multiple one field by another Return Value Example Return Value: X*.XXXXXX....-X*.XXXXX e.g. 21.000000, 9...

DMath: (A*B)/C Multiplies A and B together and then divides by C Purpose Use this function to: Divide the product of (A and B) by C Calculate ratios Return Value Example Return Value: X*.XXXXXX....-X*.XXXXX e.g. 21.000000, 9875...

DMath: (A+B)/C Adds A to B and then divides by C Purpose Use this function to: Divide the sum of (A + B) by divisor C Calculate ratios Return Value Example Return Value: X*.XXXXXX....-X*.XXXXX e.g. 21.000000, 98754654.123456, -...

DMath: (A-B)/C Subtracts B from A and then divides by C Purpose Use this function to: Divide the difference of (A + B) by divisor C Calculate ratios Return Value Example Return Value: X*.XXXXXX....-X*.XXXXX e.g. 21.000000, ...

DMath: A+B+C Adds together A, B and C Purpose Use this function to: Calculate the sum of (A, B and C) Return Value Example Return Value: X*.XXXXXX....-X*.XXXXX e.g. 21.000000, 98754654.123456, -5.000000, -654.320000 Record se...

DMath: A+B+C+D Adds together 4 values, A,B,C and D Purpose Use this function to: Calculate the sum of A, B, C and D Return Value Example Return Value: X*.XXXXXX....-X*.XXXXX e.g. 21.000000, 98754654.123456, -5.000000, -654.32000...

DMath: (A*B)+(C*D) Multiples A by B, and C by D, and then adds the two products together Purpose Use this function to: Add together the result of product AB and product CD Return Value Example Return Value: X*.XXXXXX....-X*.XXXXX ...

DMath: (A*B)+(C*D)+(E*F) Multiplies A by B, C by D, D by E and then adds the three products together Purpose Use this function to: Add together the results of products AB, CD and DE Return Value Example Return Value: X*.XXXXXX.......

DMath: INT(A*B)/B Multiplies the integer portions of (A and B) together and then divides by full value of B INT(A*B)/B = ( INT(A) * INT(B) ) / B where INT(A) = integer portion of A (8.953 -> 8 , 7.18 -> 7, -5.87 -> -5 ) INT(...

DMath: MAX(MIN(A,B),C) Calculates the minimum of (A or B) then returns the maximum of the selected value or C Purpose Use this function to: Compare value C to whichever is lower out of A or B First find the minimum of 2 values, and then c...

DMath: MAX(A,B) Returns the maximum of values A and B Purpose Use this function to: Compare 2 values and return the higher number Calculate the maximum Return Value Example Return Value: X*.XXXXXX....-X*.XXXXX e.g. 21.000000, 9...

DMath: MIN(A,B) Returns the minimum of values A and B Purpose Use this function to: Compare 2 values and return the lower number Calculate the minimum Return Value Example Return Value: X*.XXXXXX....-X*.XXXXX e.g. 21.000000, 98...

DMath: RAND(A) Creates a random and equal distribution of values between 0 and A Purpose Use this function to: Create evenly distributed Random data Return Value Example Return Value: X*.XXXXXX....-X*.XXXXX e.g. 21.000000, 9...