AJBSystemsVariances shown are for file 1 vs file 2 (base), hence the sequence of files is significant.
Does not use any classification variables, so is applicable to all sales and P&L databases.
Period must be January to December.
Variance option must be Period Totals only.1AddSelectedFileOrPeriod010101Jan|F1~None-12AddSelectedFileOrPeriod010102Jan|F2~None-13AddPercentageVarianceColumnXvsColumnY0102#0.0Jan|%VarIgnoreVarianceSigns-14AddSelectedFileOrPeriod020201Feb|F1~None-15AddSelectedFileOrPeriod020202Feb|F2~None-16AddPercentageVarianceColumnXvsColumnY0405#0.0Feb|%VarIgnoreVarianceSigns-17AddSelectedFileOrPeriod030301Mar|F1~None-18AddSelectedFileOrPeriod030302Mar|F2~None-19AddPercentageVarianceColumnXvsColumnY0708#0.0Mar|%VarIgnoreVarianceSigns-110AddSelectedFileOrPeriod040401Apr|F1~None-111AddSelectedFileOrPeriod040402Apr|F2~None-112AddPercentageVarianceColumnXvsColumnY1011#0.0Apr|%VarIgnoreVarianceSigns-113AddSelectedFileOrPeriod050501May|F1~None-114AddSelectedFileOrPeriod050502May|F2~None-115AddPercentageVarianceColumnXvsColumnY1314#0.0May|%VarIgnoreVarianceSigns-116AddSelectedFileOrPeriod060601Jun|F1~None-117AddSelectedFileOrPeriod060602Jun|F2~None-118AddPercentageVarianceColumnXvsColumnY1617#0.0Jun|%VarIgnoreVarianceSigns-119AddSelectedFileOrPeriod070701Jul|F1~None-120AddSelectedFileOrPeriod070702Jul|F2~None-121AddPercentageVarianceColumnXvsColumnY1920#0.0Jul|%VarIgnoreVarianceSigns-122AddSelectedFileOrPeriod080801Aug|F1~None-123AddSelectedFileOrPeriod080802Aug|F2~None-124AddPercentageVarianceColumnXvsColumnY2223#0.0Aug|%VarIgnoreVarianceSigns-125AddSelectedFileOrPeriod090901Sep|F1~None-126AddSelectedFileOrPeriod090902Sep|F2~None-127AddPercentageVarianceColumnXvsColumnY2526#0.0Sep|%VarIgnoreVarianceSigns-128AddSelectedFileOrPeriod101001Oct|F1~None-129AddSelectedFileOrPeriod101002Oct|F2~None-130AddPercentageVarianceColumnXvsColumnY2829#0.0Oct|%VarIgnoreVarianceSigns-131AddSelectedFileOrPeriod111101Nov|F1~None-132AddSelectedFileOrPeriod111102Nov|F2~None-133AddPercentageVarianceColumnXvsColumnY3132#0.0Nov|%VarIgnoreVarianceSigns-134AddSelectedFileOrPeriod121201Dec|F1~None-135AddSelectedFileOrPeriod121202Dec|F2~None-136AddPercentageVarianceColumnXvsColumnY3435#0.0Dec|%VarIgnoreVarianceSigns-137AddSelectedFileOrPeriod011201Annual|F1~None-138AddSelectedFileOrPeriod011202Annual|F2~None-139AddPercentageVarianceColumnXvsColumnY3738#0.0Annual|%VarIgnoreVarianceSigns-1falsefalse