Show TOC

Syntax documentationDERIVE_YTD Locate this document in the navigation structure

DERIVE_YTD(%ytd_acc%,%flow_acc%)

This is the only formula in the library that generates an MDX logic query and, as such, must be used on its own or as part of an MDX logic section.

This formula can be used to read a YTD amount from a PERIODIC application set, and store it in another account. Typically, it can create the net profit in balance sheet from the net profit in profit and loss.

Parameters:

%ytd_acc% The account to write in YTD view (LEQ)

%flow_acc% The account to read in YTD view (INC)

Define a rule that invokes this subroutine, as in the following example:

DERIVE_YTD(CYNI, NetIncome)