Okay, I think I am losing my mind.
Look at this calculation:
Now look at the results:
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!