AJBSystemsVariances 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 sales databases. Period must be January to December. Variance option must be Period Totals only. This definition is created by setting an advanced property that uses a specified data type for relevant columns.1AddSelectedFileOrPeriodCMCM01CM~|Units|F1~None02AddSelectedFileOrPeriodCMCM02CM~|Units|F2~None03AddVarianceColumnXvsColumnY0102CM~|Units|VarNone-14AddPercentageVarianceColumnXvsColumnY0102##0.0CM~|Units|% VarNone-15AddSelectedFileOrPeriodCMCM01CM~|Value|F1~None16AddSelectedFileOrPeriodCMCM02CM~|Value|F2~None17AddVarianceColumnXvsColumnY0102CM~|Value|VarNone-18AddPercentageVarianceColumnXvsColumnY0102##0.0CM~|Value|% VarNone-19AddSelectedFileOrPeriod01CM01January to CM~|Units|F1~None010AddSelectedFileOrPeriod01CM02January to CM~|Units|F2~None011AddVarianceColumnXvsColumnY0910January to CM~|Units|VarNone-112AddPercentageVarianceColumnXvsColumnY0910##0.0January to CM~|Units|% VarNone-113AddSelectedFileOrPeriod01CM01January to CM~|Value|F1~None114AddSelectedFileOrPeriod01CM02January to CM~|Value|F2~None115AddVarianceColumnXvsColumnY1314January to CM~|Value|VarNone-116AddPercentageVarianceColumnXvsColumnY1314##0.0January to CM~|Value|% VarNone-1falsefalse