Scale financial results using a dummy currency

For high-level consolidations, you may want fewer place-holding zeros than are present at the reporting level or are present at lower level consolidations. This presents a big picture report that is more easily understood, similar to the Balance Sheet and Income statement in a company's annual report, where single digits may represent millions.

This is done using a consolidating currency. By adding a new currency that is worth 1000 times more or 1,000,000 times more than the triangulation currency, and performing a high-level consolidation in this currency, all results will have three less zeros at the end, or six less zeros at the end. A dummy currency ID such as CNS with an xlttype M could be created, and the XCHANGE table would need the appropriate lines giving an exchange rate of 0.001 or 0.000001, which would mean that a consolidation into this currency would be the same as a consolidation into the triangulation currency only one-thousand, or one-million times smaller.