Calculate sum of all fields in JavaScript

alya14

SOLVED CLOSED ACTIVE ANSWERED
User: alya14
Posted: on Apr 27, 2021 10:54 PM
Forum: JavaScript
Answer: 1
Views: 3091

hi,

how to convert a field to money

I have a field like decimal in javascript

I want to sum all field.

var a = "15.650.45";
var b = "17.845.55";
var c="1";
var d="15"
var e=165		
var result=?

last 2 number is decimal value.

15.650.45 + 17.845.55 = 33,496

33,496 + 1 =33,497

33,497 + 15 = 33,512

33,512 + 165 =33,677

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 1

Reply
ANSWER
User: dharmendr
Replied: on Apr 27, 2021 11:01 PM
Modified: on May 04, 2021 06:48 AM
Report

Hi alya14,

Refer beolow code.

JavaScript

<script type="text/javascript">
    window.onload = function () {
        var a = "15.650.45";
        var b = "17.845.55";
        var c = "1";
        var d = "15"
        var f = 165

        if (a.toString().split('.').length > 1) {
            a = a.toString().replace(".", "");
        }
        if (b.toString().split('.').length > 1) {
            b = b.toString().replace(".", "");
        }
        if (c.toString().split('.').length > 1) {
            c = c.toString().replace(".", "");
        }
        if (d.toString().split('.').length > 1) {
            d = d.toString().replace(".", "");
        }
        if (f.toString().split('.').length > 1) {
            f = f.toString().replace(".", "");
        }

        var total = parseFloat(a) + parseFloat(b) + parseFloat(c) + parseFloat(d) + parseFloat(f)
        alert(total.toString().replace(/\B(?=(\d{3})+(?!\d))/g, ","));
    }
</script>

Demo

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Calculate sum of all fields in JavaScript

Company

Explore

Follow us

Contact Us