Question 36279 in Jquery Question posted in
The official Jquery Api Documentation can be found here.

Jquery Adding tax to price with commas

I am having trouble calculating with commas in my price what would be de best solution to solve this?

I am console log the right price and want to get the tax.

example console log: "€1.652,89"

                $(document).ajaxSuccess(function() {
                    var price = $('.yith_wcp_group_final_total').text();
                    
                    
                    console.log(price);
                    var tax = 21
                    var total = (price * tax) / 100;
                    $('#B_subtotal').html(total);
                    console.log(total);
                });

//EDIT

            $(document).ajaxSuccess(function() {
                  var price = $('.yith_wcp_group_final_total').text();
                    price = Number(price.replace(/[^0-9.-]+/g,""));
                    console.log(price)
                    var tax = 21
                    var total = price * (100 + tax) / 100;
                    var roundup = total.toFixed(2);
                    $('#B_subtotal').html(roundup);
                    console.log(total);
                    console.log(roundup);
                
            });

So i get 1.900,83
and after the calculation i get 2.3000043

How could I get the comma and dots back on the right place?

Tags:

2

Answers


  1. 0

    You are getting values in a string. Just convert the string into a float as we have a decimal point and apply regex as we have a currency sign in it. Regex will check the value and we will get the value in float which can be used with tax multiplication.

      var price = $('.yith_wcp_group_final_total').text();
  price = Number(price.replace(/[^0-9.-]+/g,""));
  console.log(price)
  var tax = 21
  var total = (price * tax) / 100;
  $('#B_subtotal').html(total);

  total = price + total
  console.log(total.toLocaleString());
                
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
    Login or Signup to reply.
  2. 0

    First you need to convert "€1.652,89" from "currency" to float. In this example I used the parseLocaleNumber function (https://stackoverflow.com/a/29273131/5334486).

    This gives you float 1652.89 which can be correctly used to compute taxes and total.

    You can then format total back to currency using Intl.NumberFormat() https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Intl/NumberFormat

    let price = "€1.652,89"

const taxPercent = 21

// REMOVE THE EURO SYMBOL FROM PRICE
price = price.substring(1)

// CONVERT LOCALIZED NUMBER TO FLOAT
const priceAsNumber = parseLocaleNumber(price, 'nl')
console.log(priceAsNumber) // 1652.89

// GET TAXES
const taxAmount = priceAsNumber * taxPercent / 100
console.log(taxAmount) // 347.1069

// GET TOTAL
const total = priceAsNumber + taxAmount
console.log(total) // 1999.9969

// FORMAT TOTAL TO CURRENCY
const totalRounded = new Intl.NumberFormat('nl-NL', { style: 'currency', currency: 'EUR' }).format(total)

console.log(totalRounded) // "€ 2.000,00"


//
// HELPER FUNCTION
//
// https://stackoverflow.com/a/29273131/5334486
//
function parseLocaleNumber(stringNumber, locale) {
    var thousandSeparator = Intl.NumberFormat(locale).format(11111).replace(/p{Number}/gu, '');
    var decimalSeparator = Intl.NumberFormat(locale).format(1.1).replace(/p{Number}/gu, '');

    return parseFloat(stringNumber
        .replace(new RegExp('\' + thousandSeparator, 'g'), '')
        .replace(new RegExp('\' + decimalSeparator), '.')
    );
}
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search