pc

PC (Periodic calculation) is a group of functions that are used to perform operations with different time frequencies.

A PC function must contain a frequency and an operation to be complete. There are 7 frequencies * 5 operations = 35 different types of PC functions available.

These frequencies are available:

PCY - Periodic calculation, yearly frequency
PCH - Periodic calculation, half-yearly frequency
PCT - Periodic calculation, thirdly (four-monthly) frequency
PCQ - Periodic calculation, quarterly frequency
PCM - Periodic calculation, monthly frequency
PCW - Periodic calculation, weekly frequency
PCD - Periodic calculation, daily frequency

These operations are available:

SUM - summing
AVG - calculates average based on time periods (using successful arithmetic expressions that are not based on 0 or infinity)
COUNT - counts the number of periods
MAX - gives maximum value
MIN - gives minimum value

Syntax

The syntax depends on the frequency and operation that are selected:

PC<frequency><operation>('[node]',BOP,EOP)

see below under Use for examples.

Use

PC functions have many areas of use.

SUM - E.g. to multiply price and quantity on a daily basis use a PCDSUM function:

PCDSUM('[120]*[121]',bop,eop)

AVG - E.g. to calculate an average based on the number of time periods. If you have an income forecast (price*quantity), and price and quantity are quoted on a daily basis, the function will multiply price by quantity per day and sum up before dividing by number of days in the period.

PCDAVG('[120]*[121]',BOP,EOP)

The same can be done using the NOP function.

Remember that a number divided by zero will give an infinite number and the calculation will be wrong.

To get an average for a number of organizations, you must combine a PCSUM function with an AGGAVG function.

COUNT - To count periods. Same as the NOP function.

MAX - To find the highest value for a KPI expression within a time period, e.g. highest sales (per week) last year. (Node: 135 Sales)

PCWMAX('[135]',bop-1y+by,eop-1y+ey)

MIN - To find the lowest value for a KPI expression within a time period, e.g. the lowest absence due to illness (per day) last year.

PCDMIN('[325]/[326]',bop-1y+by,eop-1y+ey)

PC functions can also be combined with other KPI functions. In this way you can e.g. find the lowest figures for absence due to illness for a period in several organizational units by combining PC with TOP functions.