Leaderboard

Greg, I am not sure if this gets you what you are looking for. It uses ValueYear4 to get the Current Price which is not accurate. If you have Locked the Price, the actual value you want for that week is not stored in the database (I don't believe). However, I checked a new database and all the Price and ValueYear4 matched in value (except for 2 which looked like they rounded to nearest whole dollar). What this does is uses the Condition value in a CASE expression to convert to the Percent value then multiplies with the ValueYear4 to get the adjusted price per Condition. I.Price < (I.ValueYear4 * CASE I.Condition WHEN 'MT' THEN 1.5 1.05 WHEN 'NM' THEN 1 WHEN 'NM-' THEN .9 WHEN 'VF-NM' THEN .8 WHEN 'VF' THEN .66 WHEN 'FN' THEN .33 WHEN 'VG' THEN .20 WHEN 'G' THEN .13 WHEN 'FA' THEN .08 WHEN 'P' THEN .02 END) * .5 PS If you have other than the Standard Conditions (CGC for example), you will need to use Setup->Grading... to get the Text value (under Cond) and the Percent value (under % of NM) and add additional WHEN ... THEN ... statements.

Yup. That's me. A comic comic.

I'm partial to B-flat minor...