LogoLogo
HomepageWhat's NewLoginContact Us
  • Start the Journey
  • Introduction to JustPerform
  • What's new
    • April 2025
    • March 2025
    • February 2025
    • January 2025
    • December 2024
    • November 2024
    • October 2024
    • September 2024
    • August 2024
    • July 2024
    • June 2024
    • May 2024
    • April 2024
    • March 2024
    • February 2024
    • December 2023
    • November 2023
    • October 2023
    • September 2023
    • July 2023
    • June 2023
    • May 2023
    • April 2023
    • March 2023
    • February 2023
    • January 2023
    • December 2022
    • November 2022
    • October 2022
      • About Spaces
      • About Drive
      • About Modelling
      • About Governance
  • Getting Started
    • Log In
      • Get Access
      • Reset Password
    • Navigate
    • My Support
      • Get Access
      • Navigate
        • How-To Raise
        • How-To Assign
  • Process Definition
    • Modelling
      • Key Components
      • App
        • Navigate
        • How-To Guide
      • Fields
        • Key Terms
        • Navigate
        • How-To Guide
      • Functional Area
        • Navigate
        • Functional Area Detail
        • How-To Guide
      • Sheets
        • Navigate
        • Sheet Detail
          • Level 2 Header
          • Sheet Details Header
          • Layout
          • Options
          • Fields
        • Metrics
          • Navigate
          • Metric Details
        • How-To Guide
      • Models
        • Standard Model
          • How-To Guide
        • Virtual Model
          • How-To Guide
        • Advanced Models
        • Review Data
          • Features
      • Transactions
        • Journal
        • How-To Guide
      • Consolidation Features
        • Consolidation Sheet
        • How-To Guide
    • Process
      • Navigate
      • How-To Guide
      • Scenarios
        • How-To Guide
      • Flow
        • General
        • Navigate
        • How-To Guide
      • Cycle
        • Navigate
        • How-To Guide
        • My Activities
    • Calculations
      • Account Reclassification
        • Navigate
        • How-To Guide
      • Allocation
        • Navigate
        • How-To Guide
      • Account Mapping
        • Navigate
        • How-To Guide
      • Intercompany Elimination
        • Navigate
        • How-To Guide
      • Automatic Journal
        • How-To Guide
      • Currency Conversion
      • Value Driver Tree
        • Get Access
        • Navigate
        • Options
        • How-To Scenarios
          • Lookup - Same Module
          • Lookup - Different Module
          • Union
          • Time Offset
          • Functions
    • Permissions
      • Access Review
        • Navigate
      • Users
        • Navigate
        • How-To Guide
      • Role Management
        • Navigate
        • How-To Guide
    • Remote Tables
      • Files Connection
        • What's the User Flow
        • What's in Connection Schema
        • How-To Guide: By Sheet
        • How-To Guide: Multiple Sheet
        • How-To Guide: Different Sheets
    • Data Flow
      • Navigate
      • Dataflow Details
  • JustPerform 365 Connector
    • Introduction
    • Get Access
    • Navigate
      • Activities Pane
      • Explore Pane
      • Home Pane
  • Stories
    • Getting Started
    • Excel Stories
      • Stories - Design Pane
        • Header
        • Definition
        • Layout
        • Options
      • Create Stories
        • How-To Guide
        • How-To Access Stories
        • How-To Run Calculation
        • How-To Submit Workflow
      • Styles
        • How-To Guide
      • Functions
        • How-To Guide
      • Parameters
        • User flow
        • How-To (User Context)
        • How-To (Book Context)
      • Time series
      • Advanced
    • Snippets
      • Navigate
      • Types of Snippets
      • Design Pane
        • Level 2 Header
        • Snippet Header
        • Layout
        • Options
        • Fields
        • Visual
        • Styles
      • How-To Guide
        • Reports
        • Visuals
        • Input
    • Board
      • Navigate
      • How-To Guide
  • Advanced
    • Connections
      • Connection to S/4 HANA
        • How to Set Up ODP
      • Success Factor
    • Monitoring
      • Task Monitor
        • Actions
      • Event Log
        • Actions
    • General
      • Password Policy
      • Multi Language Localization
        • Enable Multi Language
        • Set Preferred Language
Powered by GitBook
On this page
  1. Process Definition
  2. Modelling
  3. Sheets
  4. Sheet Detail

Options

PreviousLayoutNextFields

Last updated 10 months ago

The Options section allows you to control data entry and display of items with no data.

  • Display items with no data in rows/columns : When checked, rows/columns without data will still be shown. Only rows/columns contains data will be displayed if unchecked.

  • Allow Input to Parent Members: By default, data entry is confined to leaf/base members. However, when this option is enabled, it permits data to be inputted at a non-base level. When data is entered at a level above leaf members, it is automatically allocated to the leaf members in accordance with their existing proportions. In cases where the leaf members have no pre-existing values, the allocation is distributed equally among them.

Sheet Options