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
  • Context
  • Refresh Details
  1. Stories
  2. Excel Stories
  3. Functions

How-To Guide

PreviousFunctionsNextParameters

Last updated 1 year ago

Context

In JustPerform, users can select a cell within a table in their template. Once a cell is chosen, the function feature enables them to display a value in that cell. This value is retrieved from the system and is based on the selected model, dimension, and attribute.

When the template is filled with data, the function feature automatically fetches the corresponding values from the system. This ensures that the displayed values are always up-to-date and accurately reflect the chosen dimensions and attributes.

To provide flexibility, users can create multiple function contexts within their template. Each function context is created by selecting a model, dimension, and attribute. This allows users to display different values based on their specific requirements. They can define as many function contexts as needed, allowing for versatile and dynamic data display in their templates.

To display the company selection in the current template, begin by navigating to the Explore tab and selecting the Function option. From there, choose the function as Context to access the functionality for displaying specific information. Next, select the appropriate model, dimension, and property that correspond to the details you want to display. Once you have configured these settings, choose the specific cell within the template where you want the company selection to be shown. After updating and selecting the function, JustPerform will automatically ensure that any changes made to the entity selection are promptly reflected in the template, keeping the displayed company information accurate and aligned with the chosen entity.

Refresh Details

To provide refresh updates in your template, users can create a Refresh Details function, offering flexibility to display specific details as per their needs. This function allows users to choose from three options: Refresh Date, Refresh Time, and Refreshed By, and then designate the cell where these details will appear. This enables users to tailor their template to showcase the information most relevant to their requirements.

Step 2 : Next, pick the field corresponding to the details you wish to display - this could be Refresh Date, Refresh Time, or Refreshed By.

  • Refresh Date: This option will display the current date in the default format, DD-MMM-YYYY, and users have the freedom to modify the format by adjusting the target cell's format in Excel.

  • Refresh Time: This function will show the current time (Server Time) in the default format, which is HH:MM:SS.

  • Refreshed By: This function will display the email address of the user who initiated the refresh, providing transparency regarding the user responsible for the action.

Step 1 : Start by navigating to the Explore tab in your template. Select the Function option from the menu by clicking . Choose the Refresh Details function.

Step 3 : Once you've configured these settings, in apply to, specify the exact cell within your template where you want the selected refresh details to be shown by clicking .

Step 4 : After making your selections and defining the function, JustPerform will automatically update the content displayed in the chosen cell in accordance with the data refreshed by clicking .

Creating Function