Example Expressions

This example shows how to report a Volume off your Source Table where your Source Quantity field is something different (e.g. Tonnes).

  • Expression Type: Single

  • Return Type: Value

  • Format String: #,##0 t

  • Aggregation: Sum

  • Filter Expression: Process=ProcessOre

  • Value Expression: GetValue(SourceOreVolume) * SourcePercentageCompleted

Copy and paste into the application:

<CustomField Name="Ore Volume" CustomFieldFormatString="#,##0 t" CustomFieldExpressionType="Single" CustomFieldFilterExpression="Process=ProcessOre" CustomFieldValueExpression="GetValue(SourceOreVolume)*SourcePercentageCompleted" CustomFieldAggregationType="Sum" CustomFieldReturnType="Value" CustomFieldAggregationWeightingInbuiltField="SourceQuantity">
</CustomField>

This example shows how to report a Quality or other percentage off your Source Table.

  • Expression Type: Single

  • Return Type: Value

  • Format String: #,##0.00%

  • Aggregation: Source Quantity

  • Filter Expression: Process=ProcessCoal

  • Value Expression: GetValue(SourceCoalQualityAsh)

Copy and paste into the application:

<CustomField Name="Matrix Distance" CustomFieldFormatString="#,##0" CustomFieldExpressionType="Single" CustomFieldFilterExpression="IsHaulProfile" 

CustomFieldValueExpression="If(HaulageOneWayDistance &lt; 4550, Text(Round(HaulageOneWayDistance/100)*100), &quot;4500&quot;)" 

CustomFieldAggregationType="Sum" CustomFieldReturnType="Filter" CustomFieldAggregationWeightingInbuiltField="SourceQuantity">
 
</CustomField>

This example demonstrates a cost of operation based on operating hours of equipment.

  • Expression Type: Per Equipment

  • Return Type: Value

  • Format String: $#,##0

  • Aggregation: Sum

  • Filter Expression: Blank

  • Equipment 1 Value Expression:

    AdjustedLoaderOperatingHours * 600 + AdjustedTruckOperatingHours * 450

  • Equipment 2 Value Expression:

    AdjustedLoaderOperatingHours * 650 + AdjustedTruckOperatingHours * 480

This example will group Benches below RL 0 as Low, 0-50 as Mid and 55+ as High.

  • Expression Type: Single

  • Return Type: Filter

  • Filter Expression: Blank

  • Value Expression: If(Between(SourceBench , SourceBenchN85, SourceBenchN5) = True, "Low", If(Between(SourceBench, SourceBench0, SourceBench50) = True, "Mid", "High"))

Copy and paste into the application:

<CustomField Name="Bench Filter" CustomFieldFormatString="#,##0" CustomFieldExpressionType="Single" CustomFieldFilterExpression="" CustomFieldValueExpression="If(Between(SourceBench , SourceBenchN85, SourceBenchN5) = True, &quot;Low&quot;, If(Between(SourceBench, SourceBench0, SourceBench50) = True, &quot;Mid&quot;, &quot;High&quot;))" CustomFieldAggregationType="Sum" CustomFieldReturnType="Filter" CustomFieldAggregationWeightingInbuiltField="SourceQuantity"></CustomField>

This example uses the Equipment Cost Custom Field example above and expands upon it by providing a cost per unit of Source Quantity.

  • Expression Type: Single

  • Return Type: Value

  • Format String: $#,##0.00 t

  • Aggregation: Source Quantity

  • Filter Expression: Blank

  • Value Expression: SafeDivide(EquipmentCost, SourceQuantity)