How to: |
You can call a function from an FML RECAP command.
RECAP name[(n)|(n,m)|(n,m,i)][/format1] = function(input1,...,['format2']);
where:
Is the name of the calculation.
Displays the value in the column number specified by n. If you omit the column number, the value appears in all columns.
Displays the value in all columns beginning with the column number specified by n and ending with the column number specified by m.
Displays the value in the columns beginning with the column number specified by n and ending with the column number specified by m by the interval specified by i. For example, if n is 1, m is 5, and i is 2, the value displays in columns 1, 3, and 5.
Is the format of the calculation. The default value is the format of the report column.
Is the function.
Are the input arguments, which can include numeric constants, alphanumeric literals, row and column references (R notation, E notation, or labels), and names of other RECAP calculations.
Is the format of the output value enclosed in single quotation marks. If the calculation's format is larger than the column width, the value appears in that column as asterisks.
This request sums the AMOUNT field for account 1010 using the label CASH, account 1020 using the label DEMAND, and account 1030 using the label TIME. The MAX function displays the maximum value of these accounts.
TABLE FILE LEDGER SUM AMOUNT FOR ACCOUNT 1010 AS 'CASH ON HAND' LABEL CASH OVER 1020 AS 'DEMAND DEPOSITS' LABEL DEMAND OVER 1030 AS 'TIME DEPOSITS' LABEL TIME OVER BAR OVER RECAP MAXCASH = MAX(CASH, DEMAND, TIME); AS 'MAX CASH' END
The output is:
AMOUNT ------ CASH ON HAND 8,784 DEMAND DEPOSITS 4,494 TIME DEPOSITS 7,961 ------ MAX CASH 8,784
Information Builders |