Ex-Exchange Variance Analysis (2 files)

Crosstab Name	Ex-Exchange Variance Analysis (2 files)
Description	Shows variances and % variances between two files split between exchange and ex-exchange
Number of Files	2 files required
Database Validity	Can be applied to all databases.
Variants	Ex-Exchange Variance Analysis (3 files) Ex-Exchange Variance Analysis (4 files)
Extra Notes	Variances shown are for file 1 vs file 2, hence the sequence of files is significant. Does not use any classification variables, so is applicable to all databases. Variance option must be Period Totals only. Select the relevant period only. File 2 should always be the BASE file. Exchange Variances will only show when the Planning Currency differs from the currency selected for the report.

Example

You want to show variances and % variances between two files split between exchange and ex-exchange.

For information on how to import this Crosstab Definition please see How to Import a Crosstab Library File.