FMLLIST: Returning an FML Tag List

How to:

Available Languages: reporting

FMLLIST returns a string containing the complete tag list for each row in an FML request. If a row has a single tag value, that value is returned.

The FMLLIST function is supported for COMPUTE but not for DEFINE. Attempts to use it in a DEFINE result in blank values.

Syntax: How to Retrieve an FML Tag List

FMLLIST('A4096V')

where:

'A4096V'

Is the required argument.

Example: Retrieving an FML Tag List With FMLLIST

SET FORMULTIPLE=ON
TABLE FILE LEDGER
HEADING
"TEST OF FMLLIST"
" "
SUM AMOUNT
COMPUTE LIST1/A36 = FMLLIST('A4096V');
FOR ACCOUNT
'1010'                 OVER
'1020'                 OVER
'1030'                 OVER
BAR                    OVER
'1030' OR '1020' OR '1010'
END

The output is:

TEST OF FMLLIST 
      AMOUNT  LIST1 
      ------  ----- 
1010   8,784  1010 
1020   4,494  1020 
1030   7,961  1030 
      ------  ------------------------------------ 
1010  21,239  1010 OR 1020 OR 1030