Ok, I'm a real newbie. I'm converting a time sheet from paper to an infopath form. I have columns marked 1-15 (first 15 days of the month), and rows for activities. So for example, I have a row for work, one for vacation, one for sick days, one for holidays, etc. I've put the 15 day fields in each row into a group, and an expression box in the last column of each row sums the 15 fields for that group.
I have each of the 15 fields set as an integer, with a default value of zero, (although I've tried setting them as text strings too). The expression box in the last column in each row) contains this formula: field24 + field25 + field26 + field27 + field28 + field29 + field30 + field31 + field32 + field33 + field34 + field35 + field36 + field37 + field38, and accurately totals the fields. The result is formatted as a whole number.
But when I try to come up with a grand total of the various activities, Infopath returns NaN. I'm trying to do this with another expression box with this formula: sum(work | Holiday | Vacation), for example (I've tried several variations of these, but everything I try returns NaN). I'm sure I could simply sum every one of the fields involved, but that seems pretty cumbersome.
The other method I tried was to total each day's time, and then total the time for all 15 days. Same result. I can't seem to find a way to get the program to add the results of two expression boxes together.
This is my first attempt at Infopath - I've worked with formlas in Word and excel, but I can't seem to solve this one. What am I doing wrong?
Thanks -
Tom Donovan