The gross profit should be based on the Sale Price not on the Regular Price. You can program this using an IF statement. IF Sale Price is blank then calculate from Regular Price, else calculate Gross Profit from Sale Price. Hope that helps! Keep up the good work!