﻿<?xml version="1.0" encoding="utf-8"?>
<CrossTab xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" AppVersion="3.2.1.24871" xmlns="http://www.ajbsystems.net">
  <UserIDLastEdited>AJBSystems</UserIDLastEdited>Variances shown are for file 1 vs file 2 or 3, 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.
Files 2 and 3 should always be BASE files.
Exchange Variances will only show when the Planning Currency differs from the currency selected for the report.<ClassificationVariables /><Columns><CrossTabColumn><OutputColIndex>1</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>011201</ColumnCode><ColumnHeaders>Value|F1~</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>2</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>011202</ColumnCode><ColumnHeaders>Value|F2~</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>3</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>0102</ColumnCode><ColumnHeaders>Tot.Var.|vs F2~</ColumnHeaders><AdvancedOptions>IgnoreVarianceSigns</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>4</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>PercentageVarianceColumnXvsColumnY</ColumnType><ColumnCode>0102#0.0</ColumnCode><ColumnHeaders>% Tot.Var.| vs F2~</ColumnHeaders><AdvancedOptions>IgnoreVarianceSigns</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>5</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>ExchangeVariance</ColumnType><ColumnCode>01120102</ColumnCode><ColumnHeaders>Exch.var.|vs F2~</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>6</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>ColumnXasPercentageOfColumnY</ColumnType><ColumnCode>0502#0.0</ColumnCode><ColumnHeaders>% Exch.var.| vs F2~</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>7</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>0305</ColumnCode><ColumnHeaders>Ex-Exch.|vs F2~</ColumnHeaders><AdvancedOptions>IgnoreVarianceSigns</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>8</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>ColumnXasPercentageOfColumnY</ColumnType><ColumnCode>0702#0.0</ColumnCode><ColumnHeaders>% Ex-Exch.| vs F2~</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>9</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>011203</ColumnCode><ColumnHeaders>Value|F3~</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>10</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>0109</ColumnCode><ColumnHeaders>Tot.Var.|vs F3~</ColumnHeaders><AdvancedOptions>IgnoreVarianceSigns</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>11</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>PercentageVarianceColumnXvsColumnY</ColumnType><ColumnCode>0109#0.0</ColumnCode><ColumnHeaders>% Tot.Var.| vs F3~</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>12</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>ExchangeVariance</ColumnType><ColumnCode>01120103</ColumnCode><ColumnHeaders>Exch.var.|vs F3~</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>13</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>ColumnXasPercentageOfColumnY</ColumnType><ColumnCode>1209#0.0</ColumnCode><ColumnHeaders>% Exch.var.| vs F3~</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>14</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>1012</ColumnCode><ColumnHeaders>Ex-Exch.|vs F3~</ColumnHeaders><AdvancedOptions>IgnoreVarianceSigns</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>15</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>ColumnXasPercentageOfColumnY</ColumnType><ColumnCode>1409#0.0</ColumnCode><ColumnHeaders>% Ex-Exch.| vs F3~</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn></Columns><OutputPercentTotalColumns>false</OutputPercentTotalColumns><OutputTotalsColumns>false</OutputTotalsColumns></CrossTab>