Example

This is the formula for a Translation gain (loss) line:

~BeginFormula~(XLTGain(Total StockHolders Equity))~EndFormula~

While you can define downfoot and translation gain/loss line formulas using formula lines, the results might not be the same. Downfoot formulas are applied before and after currency translation, and xltgain formulas are applied after currency translation. Downfoot lines are also updated in data entry as data is specified, while formulas are only updated by using Local Consolidation or Consolidate, and then refreshing the data entry view.