MAP Function

The MAP function links a map number balance to a cell in CaseView. CaseView's linkage worksheet is the quickest way to link map numbers using the MAP function. The exact syntax will be added automatically using the linkage worksheet.

Syntax

MAP(<"Sign">,"Value","Map Number")

Where

The Sign is optional and defaults to debit if not supplied. Refer to the following chart for information on the sign parameter.

Sign What it does

C

Returns the credit balance for a map number in Working Papers/Time as a positive balance.

D

Returns the debit balance for a map number in Working Papers/Time.

CO (Credit only)

Functions as an accumulator of all credit balances for a map number in Working Papers/Time.

DO (Debit only)

Functions as an accumulator of all debit balances for a map number in Working Papers/Time.

Example 1

MAP("BA","100101")

Returns the current year to date adjusted balance for map number 100101 in Working Papers/Time.

This is identical to inserting the calculation GRP("M","BA","100101").

Example 2

The following example uses a wildcard in the form of a question mark (?) to link multiple map numbers with similar numbers.

MAP("BA","1???00")

Returns year to date map number adjusted balances for all map numbers using the format specified. This function links balances from map numbers 100000, 100100, 100200, 100300 and so on.

Example 3

MAP("D","BA:YR1","100")

Returns the debit prior year adjusted balance for all accounts assigned to map number 100 in Working Papers/Time. This is identical to inserting the calculation GRP("M","BA:YR1","100").

Example 4

There is support for the balance identifier "SUB". Using this includes the children of a map number in a total.

MAP("BC:SUB", "100") gives the balance of all mapping numbers beginning with "100". It evaluates only map numbers matching the mapping mask of the map number provided. This means it returns the sum of the balances for 100.1, 100.2 etc. and ignores the balances for map numbers 1000, 1001, etc.

Related Topics