Using Sums with Tables

[Janie]

I have a non-repeating table in my form. I can't figure out how to add a row
that will sum the columns.

 

[Scott L. Heim [MSFT]]

Hi Janie,

How did you create the table? If you just added a "custom table" and placed
text boxes in each of the column/rows, you will need to have another row of
text boxes where the "Default Value" is the math expression, such as:
field1 + field2

Best regards,

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Janie]

Scott, I added a bottom row and tried to add a formula expression, but I get
an error message that says: "../my:RevCAM1../my:RevREA1" does not point to a
valid location path of a field or group."

 

[Scott L. Heim [MSFT]]

Hi Janie,

Did you use the "Insert Field or Group" button so you can navigate to the
fields you want to sum? If not, try using this to select the appropriate
fields and let me know the result.

Best regards,

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Janie]

Yes, I did. Same error.

 

[Scott L. Heim [MSFT]]

Janie,

If the error text you previously provided is correct, it seems odd. You
should be able to use the button to select a field, then manually enter the
plus symbol (+) then use the button to select the next field, manually
enter the plus symbol, etc. If this does not work, use the button to select
*just 1 field* so we can see if this field correctly reflects the value of
the field you selected.

Thanks,

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Janie]

Scott, I added two fields with a manual plus symbol between them. So the
expression reads: sum(RevCAM1+RevCAM2)

I get this error:

Argument 1 must return a node-set.

-->sum(../my:RevCAM1 + ../my:RevCM2)<--

Not sure what's going on. When I chose just one field: sum(RevCAM1), I
don't get any errors. Thanks for hanging with me on this!

 

[Janie]

Okay, here's what finally worked:

sum(RevCAM1) + sum(RevREA1)

Weird!

 

[Scott L. Heim [MSFT]]

Hi Janie,

Ah - I didn't realize you were using the "sum" function! (I made the
mistake of assuming here...my apologies.)

You found the correct method: sum(field) + sum(field)

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.