calculations based on several variables

[acd2]

i have several calculations in my queries that include several variables. each of these variables has a potential to be scored as a 1, 0 or 99. a 99 is a missing value and i want to exclude it in my calculation. any ideas? will criteria just limit my total in the calc. as opposed to limiting the value of each specific variable in the calculation. any suggestions are very much appreciated.

 

[acd2]

the thing is, i still want it to use that id, for example, i just want it to drop 99 from the calculation. but not necessarily drop the entire id if 99 is found anywhere in their data. i don't know if there is an easy answer to this problem.

thanks.