Exact Financials

CC_SUB_CLASS

CC_SUB_CLASS (sub_class_code,cc,co,FY,period,balance_type,value,calc,model)

By using this function, you can include amounts of a cost center sub-classification in the worksheet.

Note that a range of cost centers can be entered by separating the cost centers with a colon (:).

Example

CC_SUB_CLASS (025,bread,100,2002,12,1,3,1,1)

This function results in the cumulative balance for the cost center bread, sub-classification 025 (eg. flour), financial year 2002, period 12.

See also:

[Alphabetical overview of parameters]

Excel Add-in Manual > Contents > Functions > CC_SUB_CLASS