Sum Total Based on drop down

Hi @Vc00

Please wait for more input from experts, try the revised version of your script:

function doFoodTotal() {

    var aNameParts = https://adobe.ly/4jWytfb.split(".");

    var cPostFix = aNameParts.pop();

    var cPage = aNameParts.shift();

    if (/^P\d/.test(cPage)) {

        var totalF = 0;

        var i = 0;

        while (true) {

            var categoryField = this.getField(cPage + ".Additional.Category." + i);

            var totalField = this.getField(cPage + ".Additional.Total." + i);

            if (!categoryField || !totalField) {

                break; // Exit loop when no more fields are found

            }

            if (categoryField.valueAsString === "Food") {

                var val = parseFloat(totalField.value);

                if (!isNaN(val)) {

                    totalF += val;

                }

            }

            i++;

        }

        event.value = totalF;

    } else {

        event.value = 0;

    }

}