InfoPath Dev

I found it!! sum(xdMath:Eval(../my:group2/my:group3[my:Payment = "Personal Funds"], "my:Amount"))

Hi, I'm working on a Expense Report form in InfoPath, and I need to sum a field in a repeating table meeting a criteria -Déjà vu- I need to sum the 'Amount' only when the 'Payment' = "Personal Funds" Last time I had that problem, I used the Sum and Eval functions. So far this is the formula I have: ...

Ohh! I see. I am using an Form Library not a SharePoint List. My bad, I didn't notice there are different. In a Form Library, the customize form is not in the ribbon in the browser. To customize the form, I have to open the site on SharePoint Designer, open the list and then the customize form. Check out the form in the attachment..

I have tried your suggestion, but still can't figure it out. The way I initially tried was inserting a 'Person/Group Picker' field in Infopath, but when I promote it to the SP list, it comes out as a string. So when I create a view to be filter by that column is not recognized as a person. Now I when try your suggestion, I ...

Is there a way to convert a user name from a Infopath form to be an active user in a SharePoint list? I created an Infopath form that collect the name of the manager who is supposed to approve the form. I want to create a view that filtered based on that name. The problem is that SharePoint doesn't recognize that name as a network user (see ...

Thansk for your post, it works like a charm. I see how you created the formula. It will help me learn how to solve more problems. Thanks a bunch! It solves my scenario pass-pass. I still wondering how to make it work in a way it can conditionally solve the other scenarios. Is there an 'if' function?

I uploaded the form. Thanks :-)

Without an screenshot is a little difficult to visualize your scenario. As far as I understand, it seems that this can be solve using a rule that assigns a value to the filed you want to calculate. A filter might be requiered to filter the value based on the parameters you defined. Create a filed called 'location'  Select the ...

I am creating a Graduation Plan Infopath form. I am having trouble coming up with an expression to calculate the credits earned. Students earn credits by course in two semesters. This are the scenarios: pass-pass Passing the first semester, half of the credits are earned. Passing the second semester the other half of the credits are ...

Try using the From Options under the File menu. There are some options that can affect the behavior of the menu when openned in the browser. File > Info > Form Options > Web Browser