InfoPath Dev

I have 3 felds.  Field1 and Field2 contain numbers.  Field3 is the result where the formula needs to be placed.  When Field1 = 1 AND when Field2 = 2 I want to display a value of 1 in Field3 (or a value of true as example)  The formula i tried to come up with is:  substring("1", 1, ...

I have a need for a group of fields to be averaged and have the average value displayed in a separate field.  There are 12 available fields but data is not required to be entered for each field.  Instead of averaging on the 12 fields, I need to be able to average based on the number of fields that have a value in them.  I was ...

I have a calculation scenario where I would like to display text based on the evaluation of certain fields.  There are five fields which are basically subtotal fields that contain a number Field1 - Unsatisfactory Field2 - Needs Improvement Field3 - Meets Field4 - Exceeds Field5 - Far Exceeds In a 6th text box, i need to be able to ...

Thanks for the help!  This worked perfectly.

I am trying to setup a chart that consists of 5 fields, each with 5 option buttons.  The option buttons have a value of 1-5 for each field.  The requirement for these is that no matter what option buttons are selected, evaluate the buttons and display only the lowest valued field in a text box. I have successfully completed this with 2 ...

Thank you very much.  This was exactly what I was looking for.  I was looking at the count function but I didn't know how to use it for one and second how to perform multiple instances.  I appreciate the help!

I am in the process of building a performance rating form for employees.  There are 8 sections to the form, each with a set of radio buttons with the rating of Needs Improvement, Satisfactory, Meets, Exceeds, and Far Exceeds.  When a radio button is marked for a section, the employee rating is saved.  At the end of this form, I ...