Skip to main content
Dani Szwarc
Dani Szwarc
Inspiring
November 8, 2016
Answered

Substracting not providing accurate results

  • November 8, 2016
  • 1 reply
  • 543 views

Hello people, I have an SQL query that performs some profit calculations before the result is displayed.

As I was CFlooping, I noticed that while most results (chargeToCustomer - Cost = Profit) were accurate, some of them were off by 1 cent.

Since I don't know SQL server functions very well, I decided to leave the calculations to Coldfusion.

But I'm getting similar results. Out of 144 records, I have about 10 that are off by 1 cent.

Has anyone experienced something similar?

Is there any decimal function I need to add in order to respect the values? I have the perception that some values are either rounded up or down, which causes the result to be off.

My formula is extremely simple: <cfset myProfit = Charge - Cost>

No magic, not weird formulas and not hidden fees

Thank you in advance!

    This topic has been closed for replies.
    Correct answer haxtbh

    This can depend on the type of numbers you are talking about. If they are very large numbers then I would suggest looking into PreciseEvaluation - ColdFusion Help | PrecisionEvaluate

    If they are not that big then there is something else you are doing but without seeing more code of example numbers its hard to tell.

    1 reply

    H
    haxtbhCorrect answer
    Inspiring
    November 9, 2016

    This can depend on the type of numbers you are talking about. If they are very large numbers then I would suggest looking into PreciseEvaluation - ColdFusion Help | PrecisionEvaluate

    If they are not that big then there is something else you are doing but without seeing more code of example numbers its hard to tell.

      Dani Szwarc
      Dani SzwarcAuthor
      Inspiring
      November 9, 2016

      Thank you for your answer. I think my problem is the cost: it has 4 decimal places. I'll make changes and post results here.

      Terms & ConditionsAccessibility statement
      Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices