Adding the values of 5 different text fields.

[Gerben van Erkelens]

I'm new to Infopath but created a form which contain 5 different text
boxes. Day have formatting set to a decimal value which have to
display currency (Dutch €). Below those five boxes I have another one
which has the same formatting.

I searched the different discussion groups and came up with some easy
to do formula's.

I have at the moment : TB1+TB2+TB3+TB4+TB5. When verifying the formula
it states that "TB1" does not point to a valid location path of a
field or group.
Before the above I tried to sum the five boxes with: SUM(my:TB1/../
my:TB2/../my:TB3/../my:TB4/../my:TB5). I got the same error as above
only it had to do with TB5.

Both of these formula's should be working, but I can't seem to get it
to work for me.

 

[S.Y.M. Wong-A-Ton]

Your first method should work.

Use the "Insert Field or Group" button on the "Insert Formula" dialog box
when composing your formula (do not manually type in field names), and make
sure to add spaces between the fields and the plus signs.

 

[Gerben van Erkelens]

Your first method should work.

Use the "Insert Field or Group" button on the "Insert Formula" dialog box
when composing your formula (do not manually type in field names), and make
sure to add spaces between the fields and the plus signs.

---
S.Y.M. Wong-A-Tonhttp://www.bizsupportonline.net(100+ InfoPath articles, tutorials, and
solutions)








- Tekst uit oorspronkelijk bericht weergeven -

Thanks that worked! I forgot the spaces between the fields.