How to Reference Iterated Values in Chronos Calculated Fields

Overview

Chronos calculated fields are essential for dynamic data management, simplifying complex computations, and ensuring consistency by automatically updating results when source data changes. For example, in projects with both ROM and Post-Crusher/Product stockpiles, wildcards can be used to dynamically reference fields, enabling tasks such as calculating balances or grades for multiple stockpiles. This approach minimizes errors, streamlines workflows, and supports advanced scheduling and inventory tracking.

Referencing Fields Without Iteration

To reference rows directly without iteration:

• Hold Ctrl and click on the field's caption or name.

Example: Reporting ROM Stockpile Balances in a project with flow chart below:

For ROM stockpiles, you can calculate:

1. Total Balance:

    

   s("Stockpiles.*Balance")

   This sums up all fields under the same indent matching the naming pattern (any name) + Balance.

2. Weighted Average Grade:

    

   v("Stockpiles.metal") / v("Stockpiles.Total Balance")

Calculating Total Metal Content (Hidden Field):

v("Stockpiles.HGLC Balance") * v("Stockpiles.HGLC Fe") + v("Stockpiles.HGHC Balance") * v("Stockpiles.HGHC Fe") + v("Stockpiles.BG Balance") * v("Stockpiles.BG Fe") + v("Stockpiles.LG Balance") * v("Stockpiles.LG Fe")

While straightforward for a small number of fields, this method can become cumbersome when scaling to multiple entities.

Leveraging Iteration for Efficient Reporting

To streamline and simplify reporting, use Iterations. Here’s a step-by-step guide:

Step 1: Create a Custom List

Start by defining a Custom List of the entities you want to include in the report.

Step 2: Configure Your Report Rows

1. Title Row: Add a title bar as the first row.

2. Iteration Row:

   • Type: Iter
   • Data Source: CustomLists
   • Select your custom list name.

3. Stockpile Balances:

   • Row Type: Row
   • Data Source: Closing.Stockpiles
   • Item: Mining.wetTonnes
   • Filter: Source.Name → <ROMs> (your Custom List name).

4. Average Grade:

   • Row Type: Row
   • Data Source: Closing.Stockpiles
   • Item: Mining.grades_Feor any other grade fields
   • Filter: Source.Name → <ROMs>.

5. Total Balance for Custom List:

   • Row Type: Row
   • Data Source: Calculated
   • Formula:
      

     s("Stockpiles.*.Balance")

6. Hidden Calculations:

   • Add a hidden row (mark it with X in the Hidden column).
   • Use this row to calculate values for later use. Example:
      

     v("Stockpiles.<ROMs>.Balance") * v("Stockpiles.<ROMs>.Fe")
     This computes the metal content for each stockpile by multiplying balance and grade.

7. Weighted Average Grade:

   • Row Type: Row
   • Data Source: Calculated
   • Formula:
      

     s("Stockpiles.*.metal") / v("Stockpiles.Total Balance")

Final Output

This configuration generates a report table showing total balances, average grades, and more, dynamically adjusted based on your defined list. Hidden rows allow intermediate calculations to stay out of the final table view.

Key Tips

• Wildcards (*) and naming conventions play a critical role in formulas.
• Keep calculations organized using hidden rows for intermediate values.
• Iterations significantly reduce manual efforts and increase reliability for large datasets.

 

Want to learn more?

Online Help Manuals - Click here for the latest version

Learning Management System - Click here to login or here to request access