14,690,515 members
See more:
Dear,

I have a field called T_Amount data type is float,

e.g= T_Amount=11800

When i make formula in query (11800/24)*35.25=17331.25

but actually if i make in calculator (11800/24)*35.25=17331.24999

i want this full figure.

Is i need to change the data type?

What I have tried:

i was using float for amount. when i was doing divide result is not accurate
Posted
Updated 13-Apr-16 10:23am
Richard MacCutchan 12-Apr-16 6:03am

Never use float for financial amounts. Use integer or decimal.

## Solution 2

`SELECT (CONVERT(DECIMAL,11800)/24)  * 35.25`

## Solution 1

Try this query,

`SELECT CAST((11800.00/24.00) as DECIMAL(20,5)) * 35.25`

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Top Experts
Last 24hrsThis month
 OriginalGriff 255 Richard Deeming 230 Dave Kreskowiak 100 Richard MacCutchan 79 CPallini 65
 OriginalGriff 4,976 Richard Deeming 2,565 Richard MacCutchan 2,246 CPallini 1,687 Patrice T 1,320

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900