Thanks!!

well, crap on a cracker, that worked!! thanks for pointing me in the right direction besides south!!

there are thousands  . . . . can I exclude them in the where clause by using

WHERE

LEN(PROD_ID) - LEN(REPLACE(PROD_ID, '-', '')) > 1

??

Thanks for the ideas, much appreciated!

Note: this works in SSMS, but crashes in SSRS.

Of course once i asked for help, it started working with IN . . . thanks, sorry

thanks. I removed the OVER clause, but then i just got the new total without reqard to entry number. We pull from our tables . . here are two Entries...

SOLVED, thanks

Thanks Mike!

Solved . .. i was calculating DUTY SAVED outside of the temptable

DM table could be NULL, Y or N, independent of B.

But if DM is a  Y, i don't care what B is.  and Vice Versa.
I only want...

thanks, I lose the NULL lines in B. I only get the N.

(B is either Y, N or Null)  I don't want to see any of the Y's)

wow.  Two hours and i didnt notice the period instead of a comma

Wow . . . i owe you 3 beers!

thanks so much.

I finally found that using NULLIF in the denominator works for me, 
thanks

NOTE: I suppose i could put the case output into a  temp table, but kind of messy for me. thanks