grid data comparison and computing total

hadoop hadoop

How shall I compare two columns data, the second column data should not be greater than the first column and if it so focus on the second column.

And if the condition is valid then the total is computed and displayed on the third column. How can I do it using javascript?

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Deepak Verma8y ago
Accepted answer
Hi,

In this scenario, you have to call a javascript function on onchange event of first and second column textbox.
<input type="number" id="frstAssmt" min="0" value="0" runat="server" onchange="calc()">

<input type="number" id="scndAssmt" min="0" value="0" runat="server" onchange="calc()">
And you have to write the below javascript code for this:-
function calc()
{
    first = document.getElementById("frstAssmt").value;
    second = document.getElementById("scndAssmt").value;
    if(parseInt(first) > parseInt(second))
    {
        document.getElementById("ttl").value = parseInt(first) + parseInt(second);
    }
    else
    {
        document.getElementById("scndAssmt").focus();
        alert("Second column value is greater than first one.")
    }
}
Hope, this will help you out.
Thanks
Deepak Verma8y ago
Hi,

Can you please tell the exact scenario or can you share the exact code of your application? Som, maybe I will help you out after.

Thanks
hadoop hadoop8y ago
@ Deepak Verma Thank You for the reply. But I think it will work only when the table contains single row, my table has multiple rows. So will it work in such scenario? Please reply. Thank You!