>...I found a "gotcha" with currency which is calculations with currency field type cause type problems which require CAST() to convert. ...

I personally experienced that, unfortunately. :(
I needed make some multiplication calculations with currency fields and got "too big value" error and had to convert with cast.

Use double or numeric.