INFORMATIONAL ** THIS INFORMATION HAS NOT BEEN VERIFIED **

How do you use the CAL Format Code

Entry Type: Informational

Product: FRx

Application:  FRx

Version Reported: 6.7 

Subject:

How do you use the CAL Format Code in FRx.

Possible Resolution:

Whereas the TOT format code is oriented toward traditional financial reporting, the calculation (CAL) format code is similar to a spreadsheet formula. Using CAL, you can perform calculations that involve individual cells, multiplication and division, or absolute amounts (actual numbers included in the formula). To use the CAL format code, enter CAL as the Fmt Code and place a formula in the Related Rates/Rows/Unit column. The formula can include numbers and operators (+, -, / and *) and parentheses ( ) in any combination.

NOTE: You can only export TOT formulas to a Lotus or Microsoft Excel spreadsheet; CAL formulas will not export.

Indicating All or Specific Columns when you enter a row code, you must enter either a column letter with it (ex. A120 for column A, row code 120), or use the @ character to indicate all columns (ex. @120 for all columns, row 120). Any number that does not have a column letter or @ character is assumed to be a real number. In a row, the number of row codes and parentheses is limited to 256 characters. If you reference a row with a label row code, you must separate the column letter from the label with a period (.). The @ character does not require the period separator.

Samples of the CAL code: