Math Functions

Rule ID Name Long Description

SCC_RULE_ID_20120711125620

Subtract

Subtract one value from another giving a result.

Result = Sum(Value 1 - Value 2)

SCC_RULE_ID_20120711124755

Add

Add two values into a results

Result = Add(Value 1 + Value 2)

SCC_RULE_ID_20120716174126

SubtractTruncate

Subtract one value from another giving a result truncated to the precision.

Result = Sum(Value 1 - Value 2), Precision

SCC_RULE_ID_20120716173508

SubtractRound

Subtract one value from another giving a result rounded to the precision.

Result = Round(Value 1 - Value 2), Precision

SCC_RULE_ID_20120716173227

AddTruncate

Add two values together giving a result rounding to the given precision.

Result = Round(Value 1 + Value 2)

SCC_RULE_ID_20120712162241

AddRound

Add two values together giving a result rounding to the given precision.

Result = Round(Value 1 + Value 2)

SCC_RULE_ID_20120712161717

MultiplyTruncate

Multiply two values together giving a result truncating to the given precision.

Result = Truncate(Value 1 * Value 2), Precision

SCC_RULE_ID_20120712160911

MultiplyRound

Multiply two values giving a result rounding it to the given precision.

Result = Round(Value 1 * Value 2)

SCC_RULE_ID_20121204164104

AverageTruncate

Sum the contents of a list and divide by the number of items in the list, truncating the result by the precision.

Ave = Truncate(Sum(List)/Len(List), Precision)

SCC_RULE_ID_20121204163908

AverageRoundDown

Sum the contents of a list and divide by the number of items in the list, rounding down the result by the precision.

Ave = RoundDown(Sum(List)/Len(List), Precision)

SCC_RULE_ID_20121204163746

AverageRoundUp

Sum the contents of a list and divide by the number of items in the list, rounding up the result by the precision.

Ave = RoundUp(Sum(List)/Len(List), Precision)

SCC_RULE_ID_20121204163355

AverageRound

Sum the contents of a list and divide by the number of items in the list, rounding the result by the precision.

Ave = Round(Sum(List)/Len(List), Precision)

SCC_RULE_ID_20121204161244

Average

Sum the contents of a list and divide by the number of items in the list.

Ave = Sum(List)/Len(List)

SCC_RULE_ID_20120712155703

DivideRoundDown

Divide one value from another giving a result rounding down to the given precision.

Result = Divide(Value 1 / Value 2)

SCC_RULE_ID_20120712151532

DivideRoundUp

Divide on value into another giving a result rounding up to the given precision.

Result = RoundUp(Value 1 / Value 2)

SCC_RULE_ID_20120712130748

DivideTruncate

Divide one value from another giving a result truncating it to the given precision.

Result = Divide(Value 1 / Value 2)

SCC_RULE_ID_20120712125721

DivideRound

Divide one value from another giving a result rounding it to the given precision.

Result = Divide(Value 1 / Value 2)

SCC_RULE_ID_20120712121748

RoundDown

Round a numeric value to a specific number of digits.

Result = RoundDown(Value, Decimal Places)

This function performs rounding where value less than 1.0 would result the value being truncated unless the number is negative, then it is rounded down.

SCC_RULE_ID_20120712114110

RoundUp

Round a numeric value to a specific number of digits.

Result = RoundUp(Value, Decimal Places)

This function performs rounding where value greater than 0.0 would result the value being rounded to 1, and values at 0.0 would result in the value not being rounded.

SCC_RULE_ID_20120730124647

SubtractRoundUp

Subtract one value from another giving a result rounded up to the precision.

Result = RoundDown(Value 1 - Value 2), Precision

SCC_RULE_ID_20120730123301

AddRoundDown

Add two values together giving a result rounding down to the given precision.

Result = Round(Value 1 + Value 2), Precision

SCC_RULE_ID_20120730121901

MultiplyRoundDown

Multiply two values giving a result rounding down to the given precision.

Result = RoundDown(Value 1 * Value 2), Precision

SCC_RULE_ID_20120730121234

MultiplyRoundUp

Multiply two values giving a result rounding up to the given precision.

Result = RoundUp(Value 1 * Value 2), Precision

SCC_RULE_ID_20120730124327

SubtractRoundDown

Subtract one value from another giving a result rounded down to the precision.

Result = RoundDown(Value 1 - Value 2), Precision

SCC_RULE_ID_20120730123457

AddRoundUp

Add two values together giving a result rounding up to the given precision.

Result = RoundUp(Value 1 + Value 2), Precision

SCC_RULE_ID_20120711130546

Multiply

Multiply Value 2 values giving a result.

Result = Multiply(Value 1 x Value 2)

SCC_RULE_ID_20120711140717

Mod

This function performs the modulus math function, returning the remainder when dividing one number by another. Result = Modulus(Value 1 / Value 2)

SCC_RULE_ID_20120711134943

Truncate

Truncate the decimal number to a specific precision.

Result = Truncate(Value, Precision)

SCC_RULE_ID_20120711133255

Round

Round a numeric value to a specific number of digits.

Result = Round(Value, Decimal Places)

This function performs natural rounding, where value of 0.5 or higher would result the value being rounded to 1, and values lower than 0.5 would result in the value being rounded to 0.

SCC_RULE_ID_20120711131114

Divide

Divide one value from another giving a result.

Result = Divide(Value 1 / Value 2)

SCC_RULE_ID_20131119134507

StringToNumber

Convert a string to a number.

SCC_RULE_ID_20131120095322

Max

Retrieves the maximum value from a list of numbers.

SCC_RULE_ID_20131120095954

Min

Retrieves the minimum value from a list of numbers.