주 컨텐츠로 이동
문서
문서
Adaptive Planning
Create Assumption Accounts for Modeled Sheets

Create Assumption Accounts for Modeled Sheets

Assumption accounts in modeled sheets drive the data in the calculated accounts. Assumptions enable you to enter specific data on the timespan that your calculated accounts can reference. After you create the assumptions, you must also add the data in a special sheet from the sheet summary page.
  1. From the
    Sheet Summary
    , click
    Modeled Accounts
    .
  2. From the toolbar, click
    Create New Assumption Account
    .
  3. Complete the
    Account Details
     section:
    옵션 설명
    Code
    Enter a unique code. We append the code to the sheet code.
    Name
    Enter a unique name.
  4. (Optional) In the
    Account Attributes
     section, select the attribute values that you want to associate with the account.
  5. Complete the
    Data Type
     section.
    옵션 설명
    Account Time Stratum
    We lock the field. To change the setting, see Change Sheet Properties of Modeled Sheets.
    Display As
    Select:
    • Number
      : Displays a numerical value.
    • Percent
      : Displays a percent.
    Decimal Places
    Indicate how many places you want to display after the decimal point:
    • Enter any number between 0-9.
    • Select
      Currency's precision
       to follow the setting for the currency. You can use the link to review the decimal places for all your currencies.
  6. Save.
  7. Use the breadcrumbs to return to the
    Sheet Summary
     page.
  8. Click
    Assumptions
    .
    All the assumption accounts on the modeled sheet display in the rows.
  9. Enter the data for the assumptions in the timespan and save the sheet.
You can now reference the assumptions to drive the calculations in the modeled sheet.