Solved

how to accumulate a decimal total in jQuery / Javascript

Posted on 2013-02-04
6
732 Views
Last Modified: 2013-02-04
 $('span[id*="lblAmt"]').each(function () {
            $(this).css(
               'border', 'solid 1px green'
            );

            tot += $(this).text();
        });


alert(tot);

Open in new window



I've established that it loops the appropriate number of times inside the each( ).


But the total in the ALERT is wacky.


Do I need to convert the text( ) to a decimal or something or other?


How can I accumlate values like this inside the each:

415.66
434
320.17
.17


Thank you.


Please provide working javascript.
0
Comment
Question by:knowlton
  • 3
  • 2
6 Comments
 
LVL 82

Accepted Solution

by:
leakim971 earned 500 total points
ID: 38853258
what about :
var tot = 0;
 $('span[id*="lblAmt"]').each(function () {
            $(this).css(
               'border', 'solid 1px green'
            );

            tot += $(this).text() * 1; // or tot += parseFloat( $(this).text() )
        });


alert(tot);

Open in new window

0
 
LVL 5

Author Comment

by:knowlton
ID: 38853268
Yeah...it was parseFloat that I needed, I think!

  $('span[id*="lblAmt"]').each(function () {           
            tot += parseFloat($(this).text());
        });

Open in new window


alert(tot);
0
 
LVL 5

Author Closing Comment

by:knowlton
ID: 38853271
Thank you.
0
The New “Normal” in Modern Enterprise Operations

DevOps for the modern enterprise offers many benefits — increased agility, productivity, and more, but digital transformation isn’t easy, especially if you’re not addressing the right issues. Register for the webinar to dive into the “new normal” for enterprise modern ops.

 
LVL 18

Expert Comment

by:Matthew Kelly
ID: 38853272
Here is a test script that works with your example data of strings.

Essentially we use a variety of built in Javascript functions and we are sure to initialize tot to 0:
parseFloat: http://www.w3schools.com/jsref/jsref_parsefloat.asp
Math.Round: http://www.w3schools.com/jsref/jsref_round.asp

<script type="text/javascript">
//initialize tot to 0
var tot = 0;
// array of string values
var values=new Array("415.66","434","320.17",".17");
//loop through with parseFloat
for (var i=0;i<values.length;i++)
{ 
tot += parseFloat(values[i]);
}
// round to two decimal places
tot = Math.round(tot*100)/100;
//output tot, use .toFixed(2) if you want two decimal places to always show
alert(tot);
</script>

Open in new window


So for your code:

//initialize
var tot = 0;

$('span[id*="lblAmt"]').each(function () {
            $(this).css(
               'border', 'solid 1px green'
            );
            //parseFloat
            tot += parseFloat($(this).text());
        });

// round to two decimal places, use 1000 for 3 decimal places, etc. You must do this because of float values extreme decimal places.
tot = Math.round(tot*100)/100;

//output
alert(tot);

Open in new window

0
 
LVL 82

Expert Comment

by:leakim971
ID: 38853274
longer than * 1 but more explicit too...
0
 
LVL 5

Author Comment

by:knowlton
ID: 38853300
matthewstevenkelly:


Thank you for this additional info!

Tom
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Insert Button on a table 16 38
Change to file doesn't show up 16 56
HTML Anchor Link Problem 3 38
html border input line 7 16
Introduction JSON is an acronym for JavaScript Object Notation.  It is a text-string data transport mechanism, capable of representing simple or complex data structures in a consistent and easy-to-read manner.  Similar in concept to XML, but more e…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question