jquery calculations as per selected dropdown value loop

Question

Iam trying to do a calculation. When a user selects a dropdown currency. The system calculates and converts the selected currency from the dropdown to INR currency values. The records are coming from mysql db and the record count will be from one record to 300 records. Here the user needs to change each currency from the drop down and the system converts this selected currency value to INR value. Its really a hectic task. So If the user changes one currency value from dropdown, the system should change the entire row currency value to the selected dropdown value and the system should calculate on certain formulae to change the value to INR. All these is working fine.

Now the issue iam facing is to implement the formulae to the jquery.

Here is the fiddle what i have done:

Fiddle

If you can check the fiddle in the jquery part i have used a formula

 var newTotal = currency==="INR" ? totalINR : (totalINR * conversionRate / row.find('.inrvalue').val()).toFixed(3);

This above formula wrong:

The actual formula iam looking at is

if (currency==="INR")
        {
            var newTotal = totalINR; 
        } else if (currency==="USD")
        {
            var newTotal = (row.find('.total1.').val() *  row.find('.inrvalue').val());
        } else {
            var newTotal = ((row.find('.inrvalue').val() / conversionRate) * row.find('.total1.').val());
        }

How will i change the existing formulae to this? When i implement this formula, iam getting an error Uncaught Error: Syntax error, unrecognized expression: .. Help Appreciated

Instead of the old formula, i need to implement this formula. The old formula calculation is wrong. The new formule which i would implement is as follows: if (currency==="INR") { var newTotal = totalINR; } else if (currency==="USD") { var newTotal = (row.find('.total1.').val() * row.find('.inrvalue').val()); } else { var newTotal = ((row.find('.inrvalue').val() / conversionRate) * row.find('.total1.').val()); } — Sanju Menon
– Sanju Menon, Commented Mar 1, 2016 at 9:00

JulioCT · Accepted Answer · 2016-03-01 09:23:41Z

2

your function is almost right, you have only one "extra" dot after "total1"

you can safely change

 var newTotal = currency==="INR" ? totalINR : (totalINR * conversionRate / row.find('.inrvalue').val()).toFixed(3);

for

var newTotal = 0;
        if (currency==="INR")
        {
            newTotal = totalINR; 
        } else if (currency==="USD")
        {
            newTotal = (row.find('.total1').val() *  row.find('.inrvalue').val());
        } else {
            newTotal = ((row.find('.inrvalue').val() / conversionRate) * row.find('.total1').val());
        }

hope this helps

answered Mar 1, 2016 at 9:23

JulioCT

1,1278 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Sanju Menon Over a year ago

Yes it works fine..Thank you. Last question. How will i make newTotal to 3 decimals?

JulioCT Over a year ago

using the same ".toFixed(3)" you were using :)

Collectives™ on Stack Overflow

jquery calculations as per selected dropdown value loop

Fiddle

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related