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.
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.1AddSelectedFileOrPeriod011201Units|F1~None02AddSelectedFileOrPeriod011202Units|F2~None03AddVarianceColumnXvsColumnY0102Units|VarNone-14AddPercentageVarianceColumnXvsColumnY0102##0.0Units|% VarNone-15AddSelectedFileOrPeriod011201Value|F1~None16AddSelectedFileOrPeriod011202Value|F2~None17AddVarianceColumnXvsColumnY0506Value|VarNone-18AddPercentageVarianceColumnXvsColumnY0506##0.0Value|% VarNone-1falsefalse