Franchise Contract

Franchise Contract

Analyze by Dates:
  • Contract Date
  • Terminate Date
Measure Source and/or calculation
Active Count

IF Active = 'Yes'

THEN Active Count = 1 AND Inactive Count = 0

ELSE Active Count = 0 AND Inactive Count = 1

Aggregate Count

IF Sales Flag Code = 'YES'

THEN Aggregate Count = 1 AND Non Aggregate Count = 0

ELSE Aggregate Count = 0 AND Non Aggregate Count = 1

Franchise Contract Count

IF Sales Flag Code] = 'YES'

THEN Aggregate Count = 1 AND Non Aggregate Count = 0

ELSE Aggregate Count = 0 AND Non Aggregate Count = 1

Inactive Count

IF Active = 'Yes'

THEN Active Count = 1 AND Inactive Count = 0

ELSE Active Count = 0 AND Inactive Count = 1

Non Aggregate Count

IF Sales Flag Code = 'Yes'

THEN Aggregate Count = 1 AND Non Aggregate Count = 0

ELSE Aggregate Count = 0 AND Non Aggregate Count = 1

Non Taxable Count

IF Taxable Flag Code = 'E'

THEN Taxable Count = 0 AND Non Taxable Count = 1

ELSE Taxable Count = 1 AND Non Taxable Count = 0

Taxable Count

IF Taxable Flag Code = 'E'

THEN Taxable Count = 0 AND Non Taxable Count = 1

ELSE Taxable Count = 1 AND Non Taxable Count = 0

Variance Limit VarianceLimit