>How do I show only 2dp on a currency field on a report?
>It is for an invoice and so any rounding must be down, and never up.
You can use FLOOR(MTON(yValue * 100))/100 - MTON() coverts a currency expression to numeric, multiply by 100, FLOOR() returns the nearest integer equal to or less than the numeric expression, divide by 100 to convert back to a decimal.
If you want to seek 0 rather than return the next lowest value, INT() truncates the decimal fraction rather than returning the next lower value - significantly different for negative numbers.