Simple Division calculation not giving decimals

Okay, I think I am losing my mind.
Look at this calculation:
image

Now look at the results:
image

Its only showing whole numbers. I dont understand why. It seems so simple. What am i doing wrong?

Epicor seems to just decide types for numbers, it’s treating the 3600 as an integer and doing an integer division. Try 3600.0 for a double or ConvertToDecimal(3600) (maybe even a ConvertToDecimal on the time also) to force it to do a decimal calculation.

3 Likes

SQL Server performs integer division by default when both operands are integers. Use 3600.0 like Marjorie said.

Thats it! thanks!