General

Re: Combining Sum and Eval in Infopath 2010

Jimmy — Sun, 02 Oct 2011 16:10:13 GMT

Hopefully someone else can recommend a book or something, but the best I can recommend is to tinker and experiment a lot, and lurk these forums. As with anything else, there's no substitute for experience. :-)

Re: Combining Sum and Eval in Infopath 2010

Edwin Brito — Sun, 02 Oct 2011 14:46:47 GMT

Right on the spot!!

Thanks!

Where can I learn how to write these formulas?

Re: Combining Sum and Eval in Infopath 2010

Jimmy — Sun, 02 Oct 2011 12:23:53 GMT

How's this:

sum(xdMath:Eval(../my:group8[my:Color = "B/W"], "my:No_Pages * my:Times"))

Combining Sum and Eval in Infopath 2010

Edwin Brito — Sun, 02 Oct 2011 04:25:44 GMT

Ok, after 5 hours trying to solve this, I give up!!

This is what I am trying to do:

I am creating an Infopath 2010 form to request printouts in a SharePoint Library. Since i have color and blak/white pages, I need to sum the total of color pages separately from the total of black and white pages (like a sumproduct in Excel).

My formula would calculate:

Total Color = Sum ( if (Color = "Color" , No_Pages * Times)
Total B/W = Sum ( if (Color = "B/W" , No_Pages * Times)

This is how it looks in XPad:

sum(xdMath:Eval(../my:group8[../my:group8/my:Color = "B/W"], "../my:group8/my:No_Pages * ../my:group8/my:Times"))

Obviously I am making a mistake since the form doesn't calculate the values as I expected. Any suggestions?