Where in the help files do I find a list of all the field names that can be used in formulas? For example in this formula =STRCAT(" ",IF($A9==".Range","Current assets",TRIM(ADGETF("GLDATA.ACCT",$B9)))) the link.field name GLDATA.ACCT is used but I cannot find a definition for ACCT in the help files.

Thanks

Hi Lyndon,

In the Financial Reporter, you can see the list of the field names from the View menu and Account Data. They are organized by the type of data being returned. ACCT is the Account Number.

You can use File / Sent To Sheet / Account Data to create a list of these field names (symbols) in a sheet you can print or export to Excel.

You can open the sample 'SuperSpec90' to see what data value any given field name will return, plus a description of what each field code represents.

In your specific formula example, the first account number in the range defined in cell B9 is returned if the value in cell A9 is not a range.

Thank you. That is helpful. I was obviously looking in the wrong place for this information.