InfoPath Dev

Hi again everyone.

I made a form In witch some columns contain amounts.
How can i calculate all the amounts in 1 column and add them up in de lower totalcel?

Kind regards
Henny

Still havent found it...i am looking in the samples.
I got the totals from 7 different columns and need to put the total of those seven in a seperate cel.

Can anyone help me out?
tnx
Henny

I'm not sure what you're asking here, could you have an example?

If you want the sum of 7 columns per row, this should be as simple as:

col1 + col2 + col3 + col4 + col5 + col6 + col7 = col8

Hello

Also Please look at the Sample form Absence Request where this is shown in Absence Details Table.

Hope this will help you.

Again guys, tnx...it worked

I added the total of 7 different columns and put the result in another cel.

Didn't think it would be that simple, i was thinking way to complicated.
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!

Greetz
Henny

Hello

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.

GoodLuck

Thx kalyan,

I hope so, but for now I have another question.
I have 4 colums named "number" "costperunit" "Vat" and "totalcost"

I can multiply number with costperunit and get the result in totalcost.
But I need it so that the % vat wil be calculated also with the result in totalcost.

My formula sum(number) * Costperunit works fine but i must change the formula so that the vat is included in the totalcost.

I tried sum(amount) * Costperunit * percentage but that just changes the percentageinput in an amount in the percentagecolumn and it doesnt add it up in the totalcost.

Hope i can get an example for this.
Thx and greetings
Henny