What is the Export Formulas Option in FRx

Entry Type: Informational

Product: FRx

Application: Report Designer

Version Reported: All

Subject:

What is the Export Formulas Option in FRx?

Possible Resolution:

In the Catalog, the Export Formulas option is located on the Output Options tab, which is located on the Output tab. Enabling this option instructs FRx to export formulas if the selected output type is Lotus (WK1), Excel (XLS), or Excel 5 or above (via OLE). Formulas are always written to a DrillDown Viewer file to allow formulas to be included when exporting from within the DrillDown Viewer.

When the Export Formula option is used, only certain types of formulas will be exported. This is explained below.

Row Formats:

• Total rows (TOT format code) will be exported. If a total row includes a range, other total rows within that range will be counted as intermediate subtotals, and will not be included in the total. The exception to this is if another total row is the first or last row within the range. If a TOT row contains parentheses, it will not be exported.
• Calculation rows (CAL format code) will not be exported.
• If a row has an NP print control, then the row will be exported as a hidden row since it may be needed for a formula. The current implementation will always export these hidden rows, regardless of whether the Export Formula option is selected.

Column formats:

• Base calculations (used with CBR rows) will be exported.
• Simple calculations will be exported.
• Complex calculations will not be exported. A complex calculation is defined as any calculation containing parentheses.
• Columns with a SD (Suppress Details) column restriction will not export formulas since the formulas cannot be calculated.
• Columns using a formula that references a specific cell (such as B/B100) will not be exported.
• NP (non-printing) columns are always exported as hidden columns.

Note: The Export Formulas option is only supported at the Financial Report detail level. Account and Transaction detail levels will not include formulas.