I have created a form for shirt orders using repeatable tables so they can order different sizes if they would like. I have 10 rows within this repeatable table, the 1st being the size choice and the others being the different colors of shirts they can order. I can simply add the rows in repeatable tables except the price depends on the size of the shirt. Small through XL are one price and anything over XL are another price. I am trying to get the total shirts based on the size. So if anyone orders Small through XL it would total in one box and if any shirts are ordered over XL they would be totaled in a different box.
I have tried different rules based on what is selected. Ex: If shirt size equals small then set field value (of a different box) to sum the shirts. I have tried many different combinations of rules like this and it will not add up for me. I have tried a drop box based on a SharePoint list for the shirt sizes, I have tried to just input the shirt sizes in a drop box, and I have tried Option buttons instead of a drop down box.
I am maybe an average to below average Infopath user, so not sure what else to try. Any suggestions would be appreciated.
Thank you in advance.