nop

NOP (number of periods) is used to find the number of periods (years, quarters, months, weeks, days, etc.) in a given time period. The following NOP functions are available:

NOY - number of years
NOH - number of half yeas
NOT - number of thirds
NOQ - number of quarters
NOM - number of months
NOW - number of weeks
NOD - number of days

Use

Use NOP functions if you always want to show the average, even where number of periods can vary. NOP functions can also be used to calculate forecast, etc.

Example:

When you select YTD (Year to date), but you want average figures for all months to date rather than accumulated figures. Write the following:

[Node1,BOY,EOP]/NOM(BOP,EOP)

This function will always show the monthly average for each individual period and the average of all months when YTD is used, since NOM(BOP,EOP) will show one month when looking at monthly figures and number of months so far this year when looking at YTD figures, e.g. six months in June.