InfoPath Dev

hi, I have not done a complex calculation in InfoPath. Please help me with below request. The form has a couple of section and for each section, I need to calculate the section score and then add to the total score. Is this possible in Infopath, the previous person has done this in excel. Calculation Towards Total Score . (Attached jpeg for reference) ·Award a 1 for any of the cells above in red that are >= to 0%, and award a 0 for any of the cells that are = 25%, and award a 0 for 3 ·There are 8 possible points in this section Any help is much appreciated. Thanks

Well - it is most likely possible. The method would depend on your form schema. Can you attach your template to a reply under the options tab?

Hilary, Thanks for replying to my query. Attached is the sample form. Thanks P

Any chance I can also see the Excel formula? I'm having a little trouble understanding your description of the calc - if anything in red is greater than or equal to 0% and less than 25%, score is 1 for that item?

Hilary, Attached is the requirements document in excel and actual form. I zipped both together. Please let me know if you have any questions. Thanks P

I added a calculated value with a suggestion for how to manage the store - I'm simply counting each field if it meets the criteria. Save locally, right click and select design and from there you can preview. The calculated value control is causing an error in the design checker (this is an annoying InfoPath bug with filtered values in calc'd values) but you'll probably be using this in a form field instead, so I wasn't worried about fixing that.