17

Can someone please help me out with a JavaScript/jQuery solution for this arithmetic problem:

I need to subtract one number from the other.

The problem is that the numbers have a dollar sign (because its money), therefore jQuery is treating them as strings instead of numbers.

I have created two variables - toalAssets and totalLiabilites. I would like to subtract the latter from the former and place the result into another variable called netWorth.

Perhaps i need to use parseFloat()?

But I'm not sure how - This is all a little over my head!

Daniel Vassallo
  • 337,827
  • 72
  • 505
  • 443
swisstony
  • 1,667
  • 3
  • 18
  • 27
  • @Mark: he's only asked 5 questions and has 36 rep, so is obviously new to the site. – DisgruntledGoat Mar 31 '10 at 20:47
  • 3
    @Jared: You can go back to your old questions (click your username at the top) and accept answers on them if appropriate. More people will be likely to answer future questions. – DisgruntledGoat Mar 31 '10 at 20:48

3 Answers3

32
var totalLiabilites = '$52.34';
var toalAssets      = '$85.12';
var pattern         = /[^0-9.-]+/g;

var result = parseFloat(toalAssets.replace(pattern, '')) -
             parseFloat(totalLiabilites.replace(pattern, ''));

// result: 32.78

Note: In JavaScript it is recommended1 to handle money as an integer representing the number of cents (8512 instead of 85.12). This is to avoid problems with floating-point arithmetic. 0.1 + 0.2 == 0.3 returns false in JavaScript, but fortunately integer arithmetic in floating point is exact, so decimal representation errors can be avoided by scaling.

You may want to check the following post for further reading on this topic: Is JavaScript’s math broken?

You can always apply the currency-sign formatting when the values are rendered to the browser.

1Douglas Crockford: JavaScript: The Good Parts: Appendix A - Awful Parts (page 105).

Community
  • 1
  • 1
Daniel Vassallo
  • 337,827
  • 72
  • 505
  • 443
6

parseFloat() won't work because your string begins with a non-number, the dollar sign.

You can simply do a replace to remove the dollar sign, along with a parseFloat to get the value:

totalAssets = parseFloat(totalAssets.replace('$', ''));
totalLiabilities = parseFloat(totalLiabilities.replace('$', ''));

var difference = '$' + (totalAssets - totalLiabilities);

This code replaces your original strings with floats. You could load them into new variables as well. Likewise, difference does not have to have the '$' prepended.

Jeff B
  • 29,943
  • 7
  • 61
  • 90
1
var a = "$20";
var b = "$34";
var c = parseFloat(a.replace(/[^0-9\.]+/g, "")) - parseFloat(b.replace(/[^0-9\.]+/g, ""));
alert(c);
makeitmorehuman
  • 11,287
  • 3
  • 52
  • 76