InfoPath Dev

Thank you. This definitely simplified things for the 3 sections, however, I cannot for the life of me figure out the RoI and Annualized 5yr Return calculations. In a spreadsheet shared with me in excel, the formula is the total of Benefits (Yr1) divided by total of one-time cost estimate (yr1) plus total of ongoing cost estimate (yr1). This ...

Thank you so much for your help. No rush!

You are accurate with your assessment. This is not in production. I am only testing this out currently. I am fairly new to InfoPath, so trying to determine if I can recreate an excel spreadsheet using InfoPath and eventually populating the data into Project Online. Thanks!

I have added the attachment. I am trying to add the total of section one (example yr 1) and the total of section 2 (yr 1) and then dividing that sum by the benefits section total (yr 1) to get the ROI total (for yr 1) as a perecentage (ex. 24.75%) Any help would be greatly appreciated!!! Thanks in advance!

I created three section of table data and a total field (calculated value) that adds up the data from each section. I now need to create a formula that adds two of the sections (total) together and then divides that by the 3rd section. When I try what makes logical sense, I get the following message in the field : -1.#IND I tried just ...