Available Formulas

You can use the following formulas when defining advanced formula calculations.

COMPANY_YTD
With the COMPANY_YTD function in IBM® Cognos® Controller, you can retrieve information that spans companies and varies over time, to use it in advanced formula calculations.
VALYTD
This function fetches YTD values for a given account, actuality, and period. It is suitable for all account types.
VALPER
This function fetches period values for a given account, actuality, and period. The YTD values of two periods are used: the period itself and the period before. For the first period of the year, the period value is equal to the YTD value. This formula is suitable for profit and loss accounts.
AVERYTD1
This function computes an average that is based on YTD values for two or more periods for an account and actuality.

Parent topic: Define formulas for advanced formula calculation accounts