Contact Us
Index
Version 20.3
Version 20.4 Version 21.1 Version 25.2 Version 25.3 Version 25.4 Version 26.1 Version 26.2 Version 26.3
Contact Us
Wands for Oracle Cloud 20.3 – Home
insightsoftware
Installation
Logging On
Insert insightsoftware Function
Combine Text
Last Refreshed By
Last Refreshed Time
Split Text
Tools (insightsoftware)
Snapshot
Shared Templates Drive
Drive Types
Dropbox
File Server
Cloud Connector
Navigator
Create a File
Delete a File
Edit a File
Open a File
Common Options
Administrator
System Administrator Options
System Administrator User Options
System Administrator Delimiter Options
System Administrator Configuration Options
System Administrator Server Information
About
Exit
Help and Shortcuts
Excel Error
GL Wand
Ledger and Segment Selector
Discover
Discover Segment Values
Discover Level
Discover Period Names
Discover Segment Properties
Expand and Explode
Expand Segment Values
Expand Segment Value Hierarchy
Explode Segment Values
Explode Segment Value Hierarchy
List of Values
List of Values – Create
Insert GL Wand Function
Account Type
Enabled Flag
Functional Currency
Get Average Balance Summary
Get Balance
Get Balance Options
Multiple Ledgers
Ledger Name
Ledger Set
Next Segment Value
Parent Flag
Period Name
Period Offset
Previous Segment Value
Segment Description
Segment End Date
Segment Tree
Segment Start Date
Calculating
Execute Drilldown
Drill Criteria Sheets
Drill Criteria – Balance
Drill Using a Saved Template
Customize Drilldown
Edit Template Layout
Save Template Layout
Manage Templates
GL Wand Tools
Other Tools
Clean Template
Create a Template
Template Storage Requirement
Edit a Template
Delete a Template
Hide Zeros
GL Wand User Options
chat icon - ignore
Live Chat
Chat Offline

Period Offset

Returns the period name that is the specified number of periods into the past or the future.

Parameter Description
Period Name The period name as configured in Oracle Cloud. This parameter must be entered in exactly the same format as the period names in Oracle. For example if your period names are configured as follows “Jan-07” in Oracle Cloud and you enter “Jan-2007” or “January-07” or “jan-07” for this parameter, GL Wand will not return any data, and will instead return an Error (Period) message.
Offset Enter an offset to return the period name which is n periods before or after the entered criteria e.g. enter 3 to return 3 periods into the future or -1 to return the previous period.
Return Range Set this value to true to return the result as a range e.g. entering period Mar-07 with an offset of -2 and the Return Range parameter set true will return “Jan-07-Mar-07”. This can be used in conjunction with the CTD (Custom to Date) balance type in the Get Balance function to create rolling period reporting.
Ledger Optionally enter a Ledger Id to bind the formula to a specific Ledger. If this parameter is omitted, the Ledger currently selected in the Ledger dropdown list will be used.

Example: =OCL_GLW_Period_Offset(“Jan-02”,6,TRUE)