https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/3110.aspxWed, 30 Aug 2006 10:24:33 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:3110hehe0https://www.infopathdev.com:443/forums/thread/3110.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=3110Thx kalyan,<br /><br />I hope so, but for now I have another question.<br />I have 4 colums named "number" "costperunit" "Vat" and "totalcost"<br /><br />I can multiply number with costperunit and get the result in totalcost.<br />But I need it so that the % vat wil be calculated also with the result in totalcost.<br /><br />My formula <b>sum(number) * Costperunit </b>works fine but i must change the formula so that the vat is included in the totalcost.<br /><br />I tried <b>sum(amount) * Costperunit * percentage</b> but that just changes the percentageinput in an amount in the percentagecolumn and it doesnt add it up in the totalcost.<br /><br />Hope i can get an example for this.<br />Thx and greetings<br />Henny<br /><br />https://www.infopathdev.com:443/forums/thread/3109.aspxWed, 30 Aug 2006 08:17:17 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:3109Kalyan Gaddam0https://www.infopathdev.com:443/forums/thread/3109.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=3109Hello <br /><br />Glad it helped you and also keep your efforts go on in learning Infopath. I am sure you will pick up very soon to help people.<br /><br />GoodLuckhttps://www.infopathdev.com:443/forums/thread/3108.aspxWed, 30 Aug 2006 06:59:49 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:3108hehe0https://www.infopathdev.com:443/forums/thread/3108.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=3108Again guys, tnx...it worked<br /><br />I added the total of 7 different columns and put the result in another cel.<br /><br />Didn't think it would be that simple, i was thinking way to complicated. <br />Hope that learning at this rate, to pick up the rythm of infopath and xml and maybe in a year even help some people myself!<br /><br />Greetz<br />Hennyhttps://www.infopathdev.com:443/forums/thread/3107.aspxWed, 30 Aug 2006 06:44:03 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:3107Kalyan Gaddam0https://www.infopathdev.com:443/forums/thread/3107.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=3107Hello<br /><br />Also Please look at the Sample form Absence Request where this is shown in Absence Details Table. <br /><br />Hope this will help you.https://www.infopathdev.com:443/forums/thread/3106.aspxWed, 30 Aug 2006 01:02:24 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:3106Matt Faus0https://www.infopathdev.com:443/forums/thread/3106.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=3106I'm not sure what you're asking here, could you have an example?<br /><br />If you want the sum of 7 columns per row, this should be as simple as:<br /><br />col1 + col2 + col3 + col4 + col5 + col6 + col7 = col8https://www.infopathdev.com:443/forums/thread/3105.aspxFri, 25 Aug 2006 13:47:12 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:3105hehe0https://www.infopathdev.com:443/forums/thread/3105.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=3105Still havent found it...i am looking in the samples.<br />I got the totals from 7 different columns and need to put <b>the total of those seven in a seperate cel</b>.<br /><br />Can anyone help me out?<br />tnx<br />Hennyhttps://www.infopathdev.com:443/forums/thread/1523.aspxFri, 25 Aug 2006 12:00:33 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:1523hehe0https://www.infopathdev.com:443/forums/thread/1523.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=1523Hi again everyone.<br /><br />I made a form In witch some columns contain amounts.<br />How can i calculate all the amounts in 1 column and add them up in de lower totalcel?<br /><br />Kind regards<br />Henny