There are a number of expressions available to use in the Reserve Model Generator.
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. |
Logical operators:
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. |