SC. Block Model Formulas

A+B

Add A and B

A-B

Subtract B from A

A*B

Multiply A and B

A/B

Divide A by B

A.ToLower()

Convert all upper case text (HG, Hg, hg) into lower case (hg)

Math.Min(A,B)

Return the minimum of A and B

Math.Max(A,B)

Return the maximum of A and B

N("density") <= 0 ? 0 : N("volume")

If density is less than or equal to zero, return zero volume, else return the volume field

A.Substring(0,Math.Min(3,A.Length))

Return the first three letters of A

( RowT("material")=="waste1" || RowT("material")=="waste2" ) ? "waste" : RowT("material")

If material is waste1 or waste2, then return "waste", else return the "material"

And

&&

If A is "true" and B is "true" and C is "true", return "true", else return "false"

Or

||

If A is "true" or B is "true" or C is "true", return "true", else return "false"

Equal to

==

If A is equal to B, return "true", else return "false"

Not equal to

!=

If A is not equal to B, return "true", else return "false"

Greater than

>

If A is greater than B, return "true", else return "false"

Greater than or equal to

>=

If A is greater than or equal to B, return "true", else return "false"

Less than

<

If A is less than B, return "true", else return "false"

Less than or equal to

<=

If A is less than or equal to B, return "true", else return "false"