Hi All,
I am trying to add together 2 fields that are in separate tables to a currency field out side of these
I have attached a image of how the form looks, trying to ADD Office Total and Tech total together and be populated in Grand Total
I have Scripting around all the other fields that are working perfectly
I have tried using the advanced calculation with :-
=SUM(variable_2.Office_Total,variable_3.Tech_Total)
This creates a 0 amount in the total but never changes
I have tried adding the same CSS (grandtotalsub) to Office Total and Tech Total and then the CSS (grandtotal) to Grand Total
I tried this javascript
$(document).ready(function () {
$(document).on('blur change', '.sum input', sumtotal);
function sumtotal() {
var s = 0;
$('.grandtotalsub input').each(function () {
s += parseNumber($(this).val());
});
$('.grandtotal input').val(s);
}
function parseNumber(n) {
var f = parseFloat(n); //Convert to float number.
return isNaN(f) ? 0 : f; //treat invalid input as 0;
}
});
What am I missing or need to change?
Regards
Shane