Calculations not performing as expected

[adtypeanddesign]

I'm coding a form for an event where customers can order polo shirts available in seven sizes. There are no spaces in any of the form field names; I've even deleted the underscores. All upper/lowercase matches.

The fields are MpoloSm, MpoloM, MpoloL, MpoloXL, Mpolo2X, Mpolo3X and Mpolo4x for men's shirts. Second row the fields are WpoloSm, WpoloM, WpoloL, WpoloXL, Wpolo2X, Wpolo3X and Wpolo4X for the ladies.

There are read-only fields named Mpolo and Wpolo that total up the previous respective fields. If you enter 1 in each field, it gives out the correct quantity. However, the total fields on the far right do not show the math done correctly. I'm attaching examples below of what this looks like. I believe all form fields are named correctly and that the Simplified field notation is set up correctly, as the formulas are written as Mpolo*37 and Wpolo*37, as the shirts are $37 each. I have no problem with the caps or T-shirts lines; just the men's and women's polo shirts. But I'm doing something wrong somewhere. Does anyone know how this can be fixed? Thank you.

[try67 · Accepted solution]

Check the field calculation order. The order needs to be first the shirts number fields, then the price fields, then the total field.

[adtypeanddesign]

Thank you for your answer, but where do I find this field calculation order? I've recently upgraded to DC Pro from X Pro, and don't remember having to do this in version X.

Thanks, Tim

[try67]

Then by chance you did it in the order it needed to be.

You'll find it in Form Edit mode, under More.

[adtypeanddesign]

Thanks, try67, that did the trick! Amazing that Adobe buries such an important function.