Skip to main content
Adaptive Insights
Knowledge and Support - Adaptive Insights

Edit Value Lookups

A value lookup translates a selection from a row of the sheet into time-based values. For example, benefits choices (HMO, PPO, and so on) may be associated with appropriate percentages. These percentages can then be multiplied by salaries to calculate benefits expense. The benefits choices and their percentages reside in a value lookup. 

To edit a value lookup for a modeled sheet:

You can edit a value lookup from a modeled sheet's summary page.  Click Value Lookups on Sheet Summary.  Or, you can edit lookups directly within the model sheet builder.

  1. Navigate to: Modeling > Model Management.

  2. Select a sheet type (Level Assigned Sheets or User Assigned Sheets), then click to open the sheet. 

  3. From Sheet Summary, click Columns and Levels

  4. Select a custom Dimension or Text Selector in the sheet builder. (center pane).

  5. In Properties (right pane), open the expander for Value Lookups.

  6.  Find the value lookup and click Edit .

  7. A sheet opens displaying rows for the dimension elements, and time period columns. Update the amounts in the cells. 

  8. When you've finished making changes, click Save .  

  • Was this article helpful?