GETCURRENTRANGE
The GETCURRENTRANGE funtion returns a range of value based on active period and period selection.
Syntax
DS.(SERIES).GETCURRENTRANGE()
Example
Consider the below table that has Sales values for all months in a year. Our objective is to find the Quarter-1 Sales value.
To get the value of First Quarter sales, we should first set the Value display as Sim.Months and keep Jan to Mar as the Simulation Period. Then give the formula as:
SUM
(
DS
._Sum_of_2023.
[Sales]
.
GETCURRENTRANGE
())
Change the Sim.Months according to the values you want to achieve. If you want to get Q4 Sales you should set the Sim.Months as Oct to Dec.
Result
Last updated