INFORMATIONAL ** THIS INFORMATION HAS NOT BEEN VERIFIED **

Formulas are not exported when Export Formulas option is selected in FRx

Entry Type: Informational

Product: FRx

Application: FRx Desktop

Version Reported: 6.7

Subject:

Formulas are not exported when Export Formulas option is selected in FRx

Possible Resolution:

When the Export Formula option is selected, only the following types of formulas will be exported:

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.

 NP print control rows 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.