Variance by Contracts

Contract on rebate:

Contact NUM CST00321464, Contract Name Northside Hospital, contract has rebate of 2%

Contract NUM CST000123460, Contract Name Piedmond Clinic, contract has no rebate

Data sample:

Contact NUM CST00321464  

Northside Hospital

Forecasted Revenue (mnthly) = 15,000

Recognized Revenue (mnthly) = 12,800

Variance between FCST - Recog Rev = 2,200

Since the contract is tied to rebate, I would like to see it excluded

Contract NUM CST000123460

Piedmond Clinic

Forecasted Revenue (mnthly) = 30,000

Recognized Revenue (mnthly) = 24,800

Variance between FCST - Recog Rev = 5,200

Since the contract is tied no rebate, Do not exclude from the output

Output results: Focus on this contract and determine why the variance occured

Contract NUM CST000123460

Piedmond Clinic

Forecasted Revenue (mnthly) = 30,000

Recognized Revenue (mnthly) = 24,800

Variance between FCST - Recog Rev = 5,200