ecgabrielsen
asked on
I need to round down to nearest decimal in MS SQL View
I need a simple formula to round down numbers the the nearest 2 decimals in an MS SQL view.
What I do would look like this in Excel:
ROUNDDOWN(Sales;2)
I have tried with Round and I am able to round to 2 decimals but the problem is it rounds up rather than down.
45,145 should in my case be 41,14.
What I do would look like this in Excel:
ROUNDDOWN(Sales;2)
I have tried with Round and I am able to round to 2 decimals but the problem is it rounds up rather than down.
45,145 should in my case be 41,14.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.