ValQ - Plan
FormulaProductChangelogStart Trial
  • Introduction to ValQ
    • Get ValQ
    • The ValQ Workflow
  • Model
    • Get Data
    • Create Model
      • Dynamic Model
      • Custom Model
      • Import a Model
    • Model Editor
      • Node Operations
      • Editor Features
    • Node Settings
    • Templates
      • Apply Template
      • Manage Template Nodes
      • Import Template
      • Export Template
    • Formula Functions
      • Logical Functions
        • IF
        • SWITCH
        • AND
        • OR
        • NOT
        • XOR
        • IFNAN
      • Math Functions
        • SUM
        • SUBTRACT
        • PRODUCT
        • DIVISION
        • AVERAGE
        • AVERAGEEXZERO
        • AVERAGEEXNEG
        • AVERAGEEXZERONEG
        • COUNT
        • ABS
        • MIN
        • MAX
        • POWER
        • SQRT
        • EXP
        • LOG
        • ROUND
        • FLOOR
        • CEILING
      • Finance Functions
        • IRR
        • NPV
        • PMT
        • IPMT
        • FV
        • PV
        • CUMIPMT
        • CUMPRINC
        • RATE
      • Range Functions
        • RANGE
        • LastNPeriods
        • Get
        • ForEach
        • findByTitle
        • GETCURRENTRANGE
        • GETROWVALUE
        • THIS_SOURCE_KEY
        • PERIOD_LOOKUP
        • PRIOR_SERIES_PERIOD_LOOKUP
      • Static Identifiers
        • THIS/ME
        • CURRENT_SERIES*
        • CURRENT_SERIES_ID*
        • CURRENT_PERIOD_INDEX
        • CURRENT_NODE_VALUES
        • DS.SERIES
      • Node Properties
        • Node Properties Explanation
    • Global Settings
  • Plan
    • Create New Plan
    • Time Series Forecasting
    • Allocation Features
      • Goal Seek
      • Distribute
      • Copy to Periods
    • Driver Based Planning
      • Enabling Driver Based Plan
      • Configuring Driver Inputs
      • Bulk Configuration of Drivers
    • Plan Interface
  • Simulate
    • Create a Scenario
    • Perform Simulations
    • Manage Scenarios
    • Simulation Interface
    • Add Notes
    • Compare Scenarios
    • Scenario Analysis by Node
    • Create Initiatives in a Scenario
      • Steps to create initiatives
    • Create your Presentation
    • Understanding the Node Components
  • Report
    • Variance Analysis Report
  • ValQ Premium FAQs
  • Glossary
  • Resources
  • Release Notes
Powered by GitBook
On this page
  1. Model
  2. Formula Functions

Range Functions

PreviousRATENextRANGE

Last updated 1 year ago

NAME
SYNTAX
DESCRIPTION

.Range(start_index,end_index)- > number

Returns the values between the specified start and end periods.

.LastNPeriods(n)- > number

Returns the values of the last 'n' periods

.Get(period_index)- > number

Returns the values of the specified period index

ForEach(Array,Iterator)

To apply the same operation for multiple nodes.

findByTitle(searchString) - > [?]

Tagging/Grouping function. Returns the value of the nodes which has the specified title

DS.(SERIES).GETCURRENTRANGE()

Returns the current range values based on the period selection.

DS.(SERIES).GETROWVALUE(sourceKey: string) - > [number]

Value of source key row

DS.(SERIES).THIS_SOURCE_KEY

Returns the value of the mentioned source key.

PRIOR_SERIES_PERIOD_LOOKUP

(seriesOffset, periodIndex, initialValue) - > [number]

Returns the specified period's value.

PERIOD_LOOKUP(offset, initialValue) - > [number]

Returns the specified series's value.

Range
LastNPeriods
Get
ForEach
findByTitle
GETCURRENTRANGE
GETROWVALUE
THIS_SOURCE_KEY
PRIOR_SERIES_PERIOD_LOOKUP
PERIOD_LOOKUP