https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/68296.aspxMon, 11 Jul 2011 13:53:03 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:68296IT_GIRL0https://www.infopathdev.com:443/forums/thread/68296.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=68296<p>Here is a snapshot of what I&#39;m actually doing. There is also a Total field which should sum the price. Price is an actual field that is calculated using quantity and unit price</p><table style="border:currentColor;width:626px;border-collapse:collapse;table-layout:fixed;word-wrap:break-word;" class="xdLayout"> <tr style="min-height:7.5pt;"> <td> <div align="center"><font style="font-size:9pt;" face="Abadi MT Condensed"><strong>Quantity</strong></font></div></td> <td style="border-top-width:1pt;border-bottom-width:1pt;border-left-width:1pt;border-top-style:solid;border-bottom-style:solid;border-left-style:solid;" colspan="3"> <div align="center"><font style="font-size:10pt;" face="Abadi MT Condensed"><strong>Description</strong></font></div></td> <td style="border-top-width:1pt;border-bottom-width:1pt;border-top-style:solid;border-bottom-style:solid;"> <div align="center"><font style="font-size:10pt;" face="Abadi MT Condensed"><strong></strong></font> </div></td> <td style="border-top-width:1pt;border-bottom-width:1pt;border-top-style:solid;border-bottom-style:solid;"> <div align="center"><font style="font-size:10pt;" face="Abadi MT Condensed"><strong></strong></font> </div></td> <td style="border-top-width:1pt;border-right-width:1pt;border-bottom-width:1pt;border-top-style:solid;border-right-style:solid;border-bottom-style:solid;"> <div align="center"><font style="font-size:10pt;" face="Abadi MT Condensed"><strong></strong></font> </div></td> <td> <div align="center"><font style="font-size:10pt;" face="Abadi MT Condensed"><strong>Department</strong></font></div></td> <td> <div align="center"><font style="font-size:10pt;" face="Abadi MT Condensed"><strong>Acct. Code</strong></font></div></td> <td> <div align="center"><font style="font-size:10pt;" face="Abadi MT Condensed"><strong>Unit Price</strong></font></div></td> <td> <div align="center"><font style="font-size:10pt;" face="Abadi MT Condensed"><strong>Price</strong></font></div></td></tr> <tr style="min-height:3.75pt;"> <td> <div align="center"> </div></td> <td style="border-top-width:1pt;border-bottom-width:1pt;border-left-width:1pt;border-top-style:solid;border-bottom-style:solid;border-left-style:solid;"> <div> </div></td> <td style="border-top-width:1pt;border-bottom-width:1pt;border-top-style:solid;border-bottom-style:solid;"> <div> </div></td> <td style="border-top-width:1pt;border-bottom-width:1pt;border-top-style:solid;border-bottom-style:solid;"> <div><font style="font-size:10pt;" color="#0000ff" face="Abadi MT Condensed"></font> </div></td> <td style="border-top-width:1pt;border-bottom-width:1pt;border-top-style:solid;border-bottom-style:solid;"> <div><font style="font-size:10pt;" color="#0000ff" face="Abadi MT Condensed"></font> </div></td> <td style="border-top-width:1pt;border-bottom-width:1pt;border-top-style:solid;border-bottom-style:solid;"> <div><font style="font-size:10pt;" color="#0000ff" face="Abadi MT Condensed"></font> </div></td> <td style="border-top-width:1pt;border-right-width:1pt;border-bottom-width:1pt;border-top-style:solid;border-right-style:solid;border-bottom-style:solid;"> <div><font style="font-size:10pt;" color="#0000ff" face="Abadi MT Condensed"></font> </div></td> <td> <div><font style="font-size:10pt;" color="#0000ff" face="Abadi MT Condensed"></font> </div></td> <td> <div align="right"><font style="font-size:10pt;" color="#0000ff" face="Abadi MT Condensed"></font> </div></td> <td> <div align="right"><font style="font-size:10pt;" color="#0000ff" face="Abadi MT Condensed"></font> </div></td> <td> <div align="right"><font style="font-size:10pt;" color="#0000ff" face="Abadi MT Condensed"></font> </div></td></tr></table>https://www.infopathdev.com:443/forums/thread/68276.aspxSat, 09 Jul 2011 03:31:30 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:68276Jimmy0https://www.infopathdev.com:443/forums/thread/68276.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=68276<p>Is Price an actual <em>field</em>, or just a calculated value displayed in your form.&nbsp; If it&#39;s not an actual field, you can do this:</p> <p>sum(eval(<strong><u>RepeatingField</u></strong>, &quot;my:Quantity * my:UnitPrice&quot;))</p>https://www.infopathdev.com:443/forums/thread/68249.aspxFri, 08 Jul 2011 19:36:05 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:68249IT_GIRL0https://www.infopathdev.com:443/forums/thread/68249.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=68249That didn&#39;t work either unless I have the syntax incorrecthttps://www.infopathdev.com:443/forums/thread/68247.aspxFri, 08 Jul 2011 19:27:14 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:68247Patrick Halstead0https://www.infopathdev.com:443/forums/thread/68247.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=68247<p>How about using the xpath function &quot;sum&quot; - sum(Price)?</p>https://www.infopathdev.com:443/forums/thread/68246.aspxFri, 08 Jul 2011 19:25:44 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:68246IT_GIRL0https://www.infopathdev.com:443/forums/thread/68246.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=68246<p>I have a field &quot;Price&quot; in my repeating table Price is a calculated field&nbsp; with the following formula Quantity * Unit Price.</p><p>I want a field &quot;Total&quot; to calculate the Sum of Price. How do I do that since in general Sum doesn&#39;t work on calculated fields?</p>