The AvailableRule control table is used to define how available dates for supply and demand are calculated in Kinaxis RapidResponse. This includes the rules for when supplies are considered available for meeting demand and vice versa, such as lead times, transit times, and other considerations that might affect when a part can realistically be expected to be available.
ReferencesThe function of the AvailableRule control table and its impact on the calculation of available dates for supplies and demands is outlined in Kinaxis RapidResponse configuration settings for supply chain planning processes.

The expression that calculates the difference between the future EffectiveUnitTransferCost and the cost to transfer today would take the future cost and subtract the current cost converted to today's date, considering the transfer quantity. The CONVERTONDATE function is used to convert the historical TransferCost to its value as of today, and then this value is divided by Quantity to get the unit cost as of today. This unit cost is then subtracted from the EffectiveUnitTransferCost to find the difference.
ReferencesThis uses the CONVERTONDATE function in Kinaxis RapidResponse, which is designed to adjust historical cost figures to their equivalent value on a different date, accounting for factors such as currency fluctuation, as outlined in the Kinaxis formula and functions documentation.

To highlight differences between scenarios, a hidden column that calculates the difference (QuantityDelta) can be created. The actual Quantity column would show the actual value, while the QuantityDelta column would calculate the difference between the baseline scenario and the comparison scenario. Conditional formatting can then be applied to the Quantity column to highlight when the QuantityDelta is not equal to zero, indicating a difference between the scenarios.
ReferencesThe method for comparing scenario data and highlighting differences using conditional formatting is a common practice in Kinaxis RapidResponse, as outlined in the application's user guide and best practices for building worksheets.

A filter based on the IndependentDemand table would improve the performance of a worksheet based on the WhereConsumedForDemand table, assuming that the demand is what drives the consumption. By filtering on IndependentDemand, you reduce the number of records the worksheet needs to process, thus improving load times and responsiveness, especially if there are a large number of records in the WhereConsumedForDemand table.
ReferencesThe Kinaxis RapidResponse documentation suggests that filtering based on driving factors such as demand can significantly enhance performance by narrowing down the data set to the most relevant records.

The expression to display the number of the calendar week from the beginning of the year takes today's date, resets it to the start of the year (the 0 Year part), and then calculates the week number from this start date, adding 1 since week numbers generally start at 1, not 0.
ReferencesThe logic for calculating week numbers from a given date is commonly described in Kinaxis RapidResponse documentation and training materials concerning date and time functions.