CalcStatus

CalcStatus is a text function that returns the calculation status of a cell for a Financial Management database connection. You can use the CalcStatus function in report headers, rows, and columns.

The function syntax is as follows:

<<CalcStatus("GridName", Row, Col, Page)>>

Argument	Description
GridName	The name of a Financial Management grid. This value must be enclosed in quotation marks
Row	Numeric value representing the row number of the grid. The first row in a grid has an index of 1, the second row has an index of 2, and so forth.
Col	A letter representing the column ID of the grid. The first column ID is A, the second column ID is B, and so on.
Page	A numeric value representing the page dimension index of the grid. The first page dimension in a grid has an index of 1, the second page dimension has an index of 2, and so forth.

The following calculation status values can be returned from Financial Management:

OK
OK - No data
OK - System Changed
Needs Subcalculate
Needs Translation
Needs Consolidation
Needs Consolidation No Data
Locked

Example

The following syntax displays the calculation status of the cell that is in row 21, column B on page 1 of Grid1:

<<CalcStatus("Grid1",21,B,1)>>

Note:

This function supports the Current keyword. For information and examples, see Current / Cur Keyword.