Hello Everyone
I need help summing my inputs for “Cost” correctly, found in my repeating group. I have a repeating group with a drop down for saved recipes, and input for recipe cost, price, and profit. All ithis information is being pulled from the database for the current user. I also have a button that will add a row when clicked. I want to add the inputs for cost when a recipe is selected from the drop down, the total cost for all the selected recipes are being displayed in another input box. I am able to sum the cost when a recipe is selcted, but if the user changes the recipe for the same drop down it will add the cost of the new recipe and the old together. Is there a way to fix this? I have screen shots of my set up below.
thanks for your help!