trailing zeros calculation in jquery with points values

Question

Hi I'm trying to calculate values with standard way like 12,000.00 or 1,678,900.00 or 0.36 values but its not calculating my values if comma or point exists. here is my code jsFiddle

for example

I'm giving the values

Payment Sent 1: 12,000.00

Payment Sent 2: 1,678,900.00

Payment Sent 3: 0.36

Now Total Payment Sent convert into 0.00 values

Total Payment Sent: 0.00

So how to calculate these values properly.

@GuruprasadRao [**that**](https://jsfiddle.net/Guruprasad_Rao/6654544h/16/) doesn't work! — Praveen Kumar Purushothaman, Aug 18 '15 at 09:21

joyBlanks · Accepted Answer · 2015-08-26T02:36:25.970

3

    function paymentSentSum() {
      var totalPaymentSent = 0;
      var that;
      $(".paymentSentSum").each(function() {
         that = parseFloat(this.value.replace(/\,/g,''));
         if(!isNaN(that) && that != 0) {
            totalPaymentSent += that;
         }
      });
      $("#paymentSentTotalPaymentSent").val((totalPaymentSent).formatMoney(2, '.', ','));
    }

    function addTrailingZerosBookings() {
      var that;
      $(".paymentSentSum").each(function() {
        that = parseFloat(this.value.replace(/\,/g,''));
        if(that && !isNaN(that)) {
            //$("#" + $(this).attr('id')).val(trailingZeros(this.value));
            if(isAlphaNumeric(that)) {
                $("#" + $(this).attr('id')).val(that.formatMoney(2, '.', ','));
            } else {
                $("#" + $(this).attr('id')).val(this.value);
            }
         }
      });
    }

Here use this. I have used parseFloat initially when to get the amount and then applied your checks. Rest all is good.

Code Pen : http://codepen.io/anon/pen/JdqLgB

edited Aug 26 '15 at 02:36

answered Aug 18 '15 at 09:23

joyBlanks

6,419
1
22
47

I guess you mistook. Read it again. – Praveen Kumar Purushothaman Aug 18 '15 at 09:27
Check out the code pen [http://codepen.io/anon/pen/JdqLgB](http://codepen.io/anon/pen/JdqLgB) it works as expected – joyBlanks Aug 18 '15 at 09:31
Man!!! I know it works, so take a +1. You still didn't understand my question or answer my question! LoL. – Praveen Kumar Purushothaman Aug 18 '15 at 09:35
there is only one problem if I enter value `12000` it convert it into `12,000.00` like this but if I enter value `12,000` with comma it is not adding trailing zeros. – user3833682 Aug 18 '15 at 09:36
and what if I enter double comma it should be convert into single comma with trailing zeros. – user3833682 Aug 18 '15 at 09:42
`Mr. joyBlanks` need a little help more. – user3833682 Aug 18 '15 at 09:45
@user3833682 tell me. was this the intent ? I am getting confused – joyBlanks Aug 18 '15 at 09:46
it is working fine but the problem is with `Number.prototype.formatMoney = function` now if I enter value `12000` its convert into `12,000.00` trailing zeros with comma, what if I enter value `12,000` with comma it is not converting my value into trailing zero so how to handle this one. – user3833682 Aug 18 '15 at 09:49
This is going to be the same replace , and etc. Give me some time I will get back – joyBlanks Aug 18 '15 at 09:57
Please look at the updated Pen [http://codepen.io/anon/pen/WvByza](http://codepen.io/anon/pen/WvByza) – joyBlanks Aug 18 '15 at 12:30
`User. joyBlanks` can you help me with this http://stackoverflow.com/questions/32205232/trailing-zeros-with-comma-functionality-using-php – user3833682 Aug 26 '15 at 12:24

trailing zeros calculation in jquery with points values

1 Answers1