Add these hidden questions to your question set. If your scheme is MultiPage, make sure you add them within your MultiPage.

1. Index Linking
   MP_IndexLinkingHeader (Header Text) – just a heading for clarity on what the hidden questions relate to.
    
2. Index Linking Date
   MP_IndexLinkingDate (Textbox) - used to check the current renewal month & year (the Record Inception Date) and populate the hidden question with an answer in the format MMM-yy (for example: Aug-25).
    
3. Buildings Index Linking
   MP_BuildingsIndexLinking (Number) – this is where the IL % amount will be stored. E.g. if the Buildings SI is to be ILed at 5%, a value of 5 will be stored here via the renewal rating file.  This step should be repeated for each additional SI to be index linked at renewal. 
    
4. Contents Index Linking
   E.g. if Contents SI should be ILed, create a question with a System ID of MP_ContentsIndexLinking.
    
5. Index Linking Last Applied
   MP_IndexLinkingLastApplied (Textbox) - This will be set in the rating file as a check to determine the last time the index linking has been applied. This prevents index linking being applied to a sum insured more than once if the rates are updated on the matrix tab or via the Re-Run Rules button.

A new file lookup will need to be created and uploaded. This should be created with a name of [Scheme Name] Index Linking – for example, Landlords Index Linking.

Note: If this file lookup ever needs to be updated AFTER being uploaded, it must be edited in Notepad or a similar Text Editor.

The lookup file should contain the following columns:

Column A - Month & Year in format Jun-22

Column B - Index Linking percentage to be applied for the corresponding month & year in column A

Column C – a repeat of column B for any additional sum insured questions which need to be index linked. In the example file lookup below, the rating file will set the number field MP_BuildingsIndexLinking we added earlier with a value of 5 for a case starting in Aug-22.

The Renewal rating file will need to be updated to store answers to our new hidden questions and apply the appropriate index linking percentage.

 Note: It is important that hidden questions are set early in the renewal rating file, prior to setting any rates against the revised sums insured.

• What we need to add and why:
  We need to SetCover for the hidden question MP_IndexLinkingDate - this will populate the hidden question with the record inception date in the format MMM-yy (forexample - Aug-22).

The purpose of this is to Timestamp MP_IndexLinkingLastApplied whenever the Index Linking has taken place, i.e. Renewal Quotation. However, it will then search for the most date of most recent Index Linking when a new Quotation is created, either a subsequent Renewal, or in the event of a Re-quote with a different Insurer. If the result is that a date within 11 months(allowing for renewal invitations) of today, it will NOT set a month to MP_IndexLinkingDate so it cannot complete the Index Lookup function, as well as set MP_IndexLinkingBuildings and MP_IndexLinkingContents to 0 so any previous Index Linking rates are not automatically applied. 

By not timestamping MP_IndexLinkingLastApplied any subsequent Quotation will recognise the last date Index Linking was successfully applied.

• Examples of a rating file:

• Next, we need to SetCoverFromLookup to populate the hidden IndexLinking question with the percentage to be applied, from the lookup file we uploaded earlier. This step should be repeated for each additional sum insured to be index linked.

• Next, we need to reset the calculation question with the current sum insured (before it has been index linked) in the question set answer, as per the example: The above step needs to be repeated for each additional sum insured being index linked. 
   

The above step needs to be repeated for each additional sum insured being index linked. 

• Now we are going to do the index linking to the calculation row charge in your question set:
  The formula we need to use is:
  FLOOR([MP_BuildingsRate_Cover]*(([MP_BuildingsIndexLinking_Cover]/100)+1))

• The final step is to update the answer in the MP question set (money question type) with the new (index linked) sum insured. This step needs to be repeated for any additional sums insured to be index linked. 

Make sure you test your updates rating file by getting a renewal quote. You´ll be able to see if your hidden questions are populated and if the correct values have been pulled through to your matrix tab.