>Thanks for the ROUND() suggestion. I believe the correct formula turns out to be something like this:
>
>round( ((curr1-curr2+1)*100)/(curr2+1),2)
>
>The +1 is to avoid divide by zero problems. I tried using max(curr2,1) inline but that seemed to throw off the parser. This probably throws things off slightly, but its good enough I think.
>
>noah
Are you converting the currencies to dollars to get an exchange rate?
Imagination is more important than knowledge