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