--- title: "Winter '26 RateIQ Calculation Rules" slug: "winter-26-rateiq-calculation-rules" tags: ["Admin", "Expanded Content", "LWC", "Winter '26"] updated: 2026-06-02T15:33:58Z published: 2026-06-02T15:33:58Z canonical: "documents.revenova.com/winter-26-rateiq-calculation-rules" --- > ## Documentation Index > Fetch the complete documentation index at: https://documents.revenova.com/llms.txt > Use this file to discover all available pages before exploring further. # Winter '26 RateIQ Calculation Rules ## **Summary** The **RateIQ** Calculation Rules Lightning Web Component (LWC) allows users the ability to create calculation rules for the RateIQ [Home Page](/previous-releases/docs/winter-26-home-rateiq) and [Load](/previous-releases/docs/winter-26-rateiq) components. The RateIQ Calculation Rules LWC is found on TMS Admin by clicking the RateIQ Calculations link. Create new or edit existing rules to control how Loads are rated. Navigate to **TMS Admin** → **Rate Calculations**. ![](https://cdn.document360.io/b89abf73-101a-4754-a781-084aef8f68dd/Images/Documentation/RateIQ%20Calculation%20Rule%20-%20button.jpg?sv=2026-02-06&spr=https&st=2026-06-02T14%3A58%3A30Z&se=2026-06-02T15%3A13%3A30Z&sr=c&sp=r&sig=umXXhJjlBIqt%2FNBRqJm1d1eSj1CAermolk2DM%2BDPct4%3D) Create new Rate Calculation records. Click **New Rate Calculation** to open the modal. Enter the following pieces of information. 1. A **Name** for the Rate Calculation. 2. Search for the **Mode** the Rate Calculation applies to. 3. Search for a **Lane** to apply this Rate Calculation, if necessary. 4. The **Match Priority** is auto-calculated if a Lane is added and adjusted when the Lane is changed. This value can be overridden. 5. Add **Description** information, as necessary. 6. Check the **Active** box to apply this calculation logic when rating applicable Modes/Lanes. ![](https://cdn.document360.io/b89abf73-101a-4754-a781-084aef8f68dd/Images/Documentation/New%20Rate%20Calculation%20modal.jpg?sv=2026-02-06&spr=https&st=2026-06-02T14%3A58%3A30Z&se=2026-06-02T15%3A13%3A30Z&sr=c&sp=r&sig=umXXhJjlBIqt%2FNBRqJm1d1eSj1CAermolk2DM%2BDPct4%3D) The new Rate Calculation opens. Configure the Rate Calculation Rules to control how the component calculates rate information by Mode and by Lane, if required. ### **Rate Calculation Rules** Rate Calculation Rules determine how the RateIQ components calculate rates. Set up the logic to weight multiple sources of rate information to create custom rating calculations. Begin adding rules with the **Add** button. ![](https://cdn.document360.io/b89abf73-101a-4754-a781-084aef8f68dd/Images/Documentation/Rate%20Calculation%20Rules%20-%20New%20-%20Button.jpg?sv=2026-02-06&spr=https&st=2026-06-02T14%3A58%3A30Z&se=2026-06-02T15%3A13%3A30Z&sr=c&sp=r&sig=umXXhJjlBIqt%2FNBRqJm1d1eSj1CAermolk2DM%2BDPct4%3D) Each time the Add button is selected another row is added to the Rules, creating a table. ![](https://cdn.document360.io/b89abf73-101a-4754-a781-084aef8f68dd/Images/Documentation/Calculation%20Rule%20Row.jpg?sv=2026-02-06&spr=https&st=2026-06-02T14%3A58%3A30Z&se=2026-06-02T15%3A13%3A30Z&sr=c&sp=r&sig=umXXhJjlBIqt%2FNBRqJm1d1eSj1CAermolk2DM%2BDPct4%3D) **Supported Data Sources** 1. TMS (org-specific rate/quote data) 2. [DAT](/previous-releases/docs/winter-26-dat) 3. [LaneIQ Network](/previous-releases/docs/winter-26-laneiq-network) 4. [FreightWaves](/previous-releases/docs/winter-26-freightwaves) 5. [Truckstop – Posted](/previous-releases/docs/winter-26-truckstop) 6. [Truckstop – Paid](/previous-releases/docs/winter-26-truckstop) 7. [Custom Source](/previous-releases/docs/winter-26-rateiq-calculation-rules#add-custom-data-as-a-rateiq-source) Select the appropriate **Data Source** and enter the remaining information in the row. 1. The **Equipment Category** picklist is dependent on the Data Source. 2. The **Paid/Posted** column contains a source-specific selection. 1. *Truckstop* rate information requires a **Paid** or **Posted** selection. 2. FreightWaves rate information is set to **Contracted**. 3. Set the **Lookback Days** to the number of days of rating data to include in the calculation. 4. Enter the **Search Radius** value to include Loads within a certain distance of the Lane. 5. Set the **Distance Units** (*Miles* or *Kilometers*) for the **Search Radius**. 6. The **Threshold** is the minimum number of Load records that fit the criteria to trigger the calculation rule into effect. 7. Enter the **Weight**. The **Weight** is the overall percentage for one specific Data Source (*TMS*, *LaneIQ Network*, *DAT*, *FreightWaves*, *Truckstop*, *Custom Sources*) for the Rate Calculation. 1. *The total weight across all Data Sources must equal 100%.* #### **Weighting Calculations** **Weighting Rules** 1. The same Equipment Category must be used across all Rules in the Rate Calculation. - *Van* for Truckload Modes - *Reefer* for Refrigerated Modes - *Flatbed* for Flatbed Modes. 2. A single **Data Source** may take into account multiple **Lookback Days** (Rules/Rows). - Each Lookback Days value must be separated and included on an individual Rule/Row. - The Rule/Row with the shortest **Lookback Days** value is checked first. - If the **Threshold** is met (enough rate data), the value is used in the Rate Calculation Rule multiplied by the **Weight**. - If the **Threshold** is not met (not enough rate data), the next shortest **Lookback Days** value is checked. - If the **Threshold** is met (enough rate data), the value is used in the Rate Calculation Rate multiplied by the **Weight**. - When **Threshold** data is not met, the next Rule/Row with the next shortest **Lookback Days** value is checked. This process continues until the **Threshold** is met or the longest **Lookback Days** value is checked and no more Rules/Rows are available. - See the *TMS*, *DAT*, and *Truckstop* (**Posted**) Rules below for an example. 3. A single **Data Source** may take into account multiple Rules/Rows. All Rules/Rows must have the same **Weight** value. 4. *The total Weight across all Data Sources must equal 100%.* - (Step 2) Rate Calculation Rules use the first valid Rule/Row for a Data Source based on the shortest/smallest **Lookback Days** value. When the shortest/smallest Rule/Row is not satisfied, the next is evaluated, and so on. The evaluations continue from shortest **Lookback Days** to longest, in order. - The following logic controls for scenarios when the *TMS* **Data Source** does not find any Load rate data (does *not* meet the **Threshold** for all **Lookback Days** Rules/Rows). - *DAT* and/or *Truckstop* data are available. - The TMS **Weight** is proportionally divided across the *DAT* and/or *Truckstop* **Data Source** Rules/Rows that qualify. ![](https://cdn.document360.io/b89abf73-101a-4754-a781-084aef8f68dd/Images/Documentation/Rate%20Calculation%20Rules%20-%20Colored.jpg?sv=2026-02-06&spr=https&st=2026-06-02T14%3A58%3A30Z&se=2026-06-02T15%3A13%3A30Z&sr=c&sp=r&sig=umXXhJjlBIqt%2FNBRqJm1d1eSj1CAermolk2DM%2BDPct4%3D) **DAT** DAT only displays rate data for a 30 day **Lookback Days** period when a Rate Calculation Rule is created for each time period less than AND including 30. Create a DAT Rate Calculation Rule for each of the following values. See the example above. - 3 - 7 - 15 - 30 #### Weighting Calculation Example Suppose a Rate Calculation was configured for the Truckload Mode with the following data sources and weights: ![TMS Data Source with a 5% weight. FreightWaves Data Source with a 80% weight. Truckstop Data Source with a 15% weight.](https://cdn.document360.io/b89abf73-101a-4754-a781-084aef8f68dd/Images/Documentation/Rate Calculation Rules with Example.png?sv=2026-02-06&spr=https&st=2026-06-02T14%3A58%3A30Z&se=2026-06-02T15%3A13%3A30Z&sr=c&sp=r&sig=umXXhJjlBIqt%2FNBRqJm1d1eSj1CAermolk2DM%2BDPct4%3D) After creating a Load using the Truckload as the mode of transportation, the RateIQ LWC populates with the following values and data sources: ![](https://cdn.document360.io/b89abf73-101a-4754-a781-084aef8f68dd/Images/Documentation/RateIQ Data Sources and Calculation Example - 1.jpg?sv=2026-02-06&spr=https&st=2026-06-02T14%3A58%3A30Z&se=2026-06-02T15%3A13%3A30Z&sr=c&sp=r&sig=umXXhJjlBIqt%2FNBRqJm1d1eSj1CAermolk2DM%2BDPct4%3D) For this example, the focus will only be on the **Freight+Fuel** values, but it also applies to Freight-only and Fuel-only values. **Denominator** Note that the TMS data source is **not** in the RateIQ LWC even though it is a Rate Calculation Rules data source. This affects the weight calculation with the following formula: $denominator = (100 - (sum\; of\; missing\; data\; sources\; weight\; percentages))$ In this example, since the TMS data source weight is 5% and is the only data source missing in the LWC, the total weight value is 95%: $100 - 5 = 95$ > [!NOTE] > **Note**: If a data source is in the RateIQ LWC but does not have a value for the column, such as **Freight** or **Fuel**, add the weight percentage for that data source along with the missing data sources when calculating the denominator. **Multiplier** To get the value to multiply each column’s value for each data source, use the **Weight** of the Data Source divided by the denominator: $multiplier = \frac{(weight\; for\; data\; source)}{denominator}$ In this example, the multiplier value for **FreightWaves** is: $\frac{80}{95} = 0.8421052631578947$ The multiplier value for **Truckstop** is: $\frac{15}{95} = 0.1578947368421053$ **Partial Value** To get the partial value to add for the calculation, multiply the column value for that data source by its multiplier value: $partial\; value = (data\; source\; value) * multiplier$ In this example, the partial value for **Freight+Fuel** from **FreightWaves** is: $2,800.55 * 0.8421052631578947 = 2,358.357894736842$ The partial value for **Freight+Fuel** from **Truckstop** is: $2,465.67 * 0.1578947368421053 = 389.3163157894738$ **Sum for Total Calculation Value** Add the partial values together and round to the nearest hundredth place to get the value for the column. In this example, the calculation value is: $2,358.357894736842 + 389.3163157894738 = 2,747.674210526316$ When the value is rounded, the calculation value for **Freight+Fuel** is $2,747.67, which is displayed at the top of the RateIQ LWC in the Load record. ## **Custom Data Sources** RateIQ components may also include additional rate data from external sources. The information below describes the process for uploading and removing other sources of rating data, as necessary. ### **Setup** Multiple custom data sources may be created and populated with external rate data for use in RateIQ components. Create new custom data sources as necessary. Complete the steps below to add custom data sources. 1. From **Setup** → **Object Manager**, find the **Rate Calculation Rule** object. 2. Select the *Fields & Relationships* tab and choose the **Data Source** field. 3. In the *Values* section, click the **New** button. 4. Enter the name of the new custom data source and click **Save**. ![](https://cdn.document360.io/b89abf73-101a-4754-a781-084aef8f68dd/Images/Documentation/Rate Calculation Rule - 1.png?sv=2026-02-06&spr=https&st=2026-06-02T14%3A58%3A30Z&se=2026-06-02T15%3A13%3A30Z&sr=c&sp=r&sig=umXXhJjlBIqt%2FNBRqJm1d1eSj1CAermolk2DM%2BDPct4%3D) 5. From the *Field Dependencies* section, choose the **Edit** link for **Equipment Category**. 6. Select the Equipment Types this custom data source may include. 7. Choose the **Include Values** button. ![](https://cdn.document360.io/b89abf73-101a-4754-a781-084aef8f68dd/Images/Documentation/Rate Calculation Rule - 2.png?sv=2026-02-06&spr=https&st=2026-06-02T14%3A58%3A30Z&se=2026-06-02T15%3A13%3A30Z&sr=c&sp=r&sig=umXXhJjlBIqt%2FNBRqJm1d1eSj1CAermolk2DM%2BDPct4%3D) 8. Click **Save**. 9. Complete steps 5 through 8 for the **Paid/Posted** and **Search Radius** picklist field dependencies. 10. Enter the Load data into the .CSV file to upload into the TMS. The **Data Source** field in the .CSV file must match the picklist value created in Step 4. ![](https://cdn.document360.io/b89abf73-101a-4754-a781-084aef8f68dd/Images/Documentation/Rate Calculation Rule - 3.png?sv=2026-02-06&spr=https&st=2026-06-02T14%3A58%3A30Z&se=2026-06-02T15%3A13%3A30Z&sr=c&sp=r&sig=umXXhJjlBIqt%2FNBRqJm1d1eSj1CAermolk2DM%2BDPct4%3D) ### **Add Custom Data** Import/Delete **Custom Source data** by clicking on the **Data** button. ![](https://cdn.document360.io/b89abf73-101a-4754-a781-084aef8f68dd/Images/Documentation/Rate%20Calculation%20Rules%20-%20Data%20button(1).jpg?sv=2026-02-06&spr=https&st=2026-06-02T14%3A58%3A30Z&se=2026-06-02T15%3A13%3A30Z&sr=c&sp=r&sig=umXXhJjlBIqt%2FNBRqJm1d1eSj1CAermolk2DM%2BDPct4%3D) From the modal, download the Revenova-provided file containing pre-formatted columns for easier data entry. ![](https://cdn.document360.io/b89abf73-101a-4754-a781-084aef8f68dd/Images/Documentation/Custom%20Source%20Data%20Upload%20Modal.jpg?sv=2026-02-06&spr=https&st=2026-06-02T14%3A58%3A30Z&se=2026-06-02T15%3A13%3A30Z&sr=c&sp=r&sig=umXXhJjlBIqt%2FNBRqJm1d1eSj1CAermolk2DM%2BDPct4%3D) To add a custom data source, download the file format. Follow the instructions in the .CSV file. 1. Enter the appropriate load data into the .CSV file. 2. **Save** the file. 3. Click the **Upload Files** button and select the .CSV OR drag the .CSV file onto the drop files section of the modal. 4. Click **Close** to exit the modal. 5. The user that uploaded 6. the file receives an email when the file finishes processing. Completion statistics are provided including the number of rows processed and any errors. #### **Add Data via TMS Web Service** Data may be imported with the *TMSRateIQSourceService* web service for the new custom data source, the **dataSource** column value must match the picklist value created in Step 4 in the [Setup](/previous-releases/docs/winter-26-rateiq-calculation-rules#setup) section above. See the [Web Services Guide](/previous-releases/docs/winter-26-revenova-tms-web-services-guide#tmsrateiqratesourceservice) for more information. ![](https://cdn.document360.io/b89abf73-101a-4754-a781-084aef8f68dd/Images/Documentation/Rate Calculation Rule - 4.png?sv=2026-02-06&spr=https&st=2026-06-02T14%3A58%3A30Z&se=2026-06-02T15%3A13%3A30Z&sr=c&sp=r&sig=umXXhJjlBIqt%2FNBRqJm1d1eSj1CAermolk2DM%2BDPct4%3D) ### **Delete Custom Data** Manually delete custom data by selecting the RateIQ Calculation record that matches the date in the row. 1. Click the **Data** button on the RateIQ Calculation Rules component. 2. Select **Custom Source** from the Data Source picklist on the File Upload modal. Enter the appropriate **From** and **To Date** fields. 3. Click the **Delete** button. The user completing the delete action receives an email when the [RateIQ Rate Source Job](/previous-releases/docs/winter-26-batch-processes) completes. Completion statistics are provided including any errors. Deleted records are found in Recycle Bin and may be restored, if needed. > [!NOTE] > Custom source data may be imported or deleted from the TMS with the *TMSRateIQSourceService* web service. See the [Web Services Guide](/previous-releases/docs/winter-26-revenova-tms-web-services-guide) for more information. A feature in Salesforce that enhances the user experience by providing interactive and customizable components within Salesforce applications. Revenova uses Lightning Web Components to deliver features that can be tailored to suit your specific needs and preferences.