AJBSystemsVariances shown are for file 1 vs file 2, 3 or 4, 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.1AddSelectedFileOrPeriodCMCM01CM~|F1~None-12AddSelectedFileOrPeriodCMCM02CM~|F2~None-13AddVarianceColumnXvsColumnY0102CM~|VarianceIgnoreVarianceSigns-14AddPercentageVarianceColumnXvsColumnY0102#0.0CM~|% Var.IgnoreVarianceSigns-15AddSelectedFileOrPeriodCMCM03CM~|F3~None-16AddVarianceColumnXvsColumnY0105CM~|VarianceIgnoreVarianceSigns-17AddPercentageVarianceColumnXvsColumnY0105#0.0CM~|% Var.IgnoreVarianceSigns-18AddSelectedFileOrPeriodCMCM04CM~|F4~None-19AddVarianceColumnXvsColumnY0108CM~|VarianceNone-110AddPercentageVarianceColumnXvsColumnY0108#0.0CM~|% Var.None-111AddSelectedFileOrPeriod01CM01YTD CM~|F1~None-112AddSelectedFileOrPeriod01CM02YTD CM~|F2~None-113AddVarianceColumnXvsColumnY1112YTD CM~|VarianceIgnoreVarianceSigns-114AddPercentageVarianceColumnXvsColumnY1112#0.0YTD CM~|% Var.IgnoreVarianceSigns-115AddSelectedFileOrPeriod01CM03YTD CM~|F3~None-116AddVarianceColumnXvsColumnY1115YTD CM~|VarianceIgnoreVarianceSigns-117AddPercentageVarianceColumnXvsColumnY1115#0.0YTD CM~|% Var.IgnoreVarianceSigns-118AddSelectedFileOrPeriod01CM04YTD CM~|F4~None-119AddVarianceColumnXvsColumnY1118YTD CM~|VarianceNone-120AddPercentageVarianceColumnXvsColumnY1118#0.0YTD CM~|% Var.None-121AddSelectedFileOrPeriod011202Annual|F2~None-122AddColumnXasPercentageOfColumnY1121#0.0Annual|% YTDNone-123AddSelectedFileOrPeriod011203Annual|F3~None-124AddColumnXasPercentageOfColumnY1123#0.0Annual|% YTDNone-125AddSelectedFileOrPeriod011204Annual|F4~None-126AddColumnXasPercentageOfColumnY1125#0.0Annual|% YTDNone-1falsefalse