Api.Pov.Time.MemberId

Api.Pov.Time.MemberId is obtained from the Time Member Id for the current POV being executed during the calculation. The Time.MemberId is stored as an unique integer to represent a single Time member. The uniqueness is determined by the combination of the Year and Period.

H1 = 001                    

Q1 = 002

M1 = 003            

M2 = 004

M3 = 005

Q2 = 006

M4 = 007

M5 = 008

M6 = 009

H2 = 010

Q3 = 011

M7 = 012

M8 = 013

M9 = 014

Q4 = 015

M10 = 016

M11 = 017

M12 = 018

The Time MemberId is constructed like this:  2019003000

The api.Pov.Time.MemberId is used as a property in many functions. Here are some of the most common functions:

  • api.Time.GetYearFromId

  • api.Time.GetPeriodNumFromId

  • api.Time.GetNumDaysInTimePeriod

  • api.Time.AddTimePeriods

  • api.Time.AddYears

Api.Pov.Time.MemberId Usage

Example using api.Pov.Time.MemberId:

ErrorLog result:

Example using api.Pov.Time.MemberId in a working formula: