Newbie Questions

Re: 2 + 2 + 2 = NaN?

witakr — Thu, 10 Feb 2011 00:10:23 GMT

That worked perfectly. Thank you for your help.

Again I apologize for ignoring your first attempt to help me. It was not my intention.

Thank you so much for your help. This and one other problem I have have been bothering me for days now. Thank you.

Jay

Re: 2 + 2 + 2 = NaN?

Jimmy — Mon, 07 Feb 2011 14:35:06 GMT

In the Function Editor dialog. You should use the Select Field... button to select each of the fields, and put plus signs between them.

Re: 2 + 2 + 2 = NaN?

witakr — Mon, 07 Feb 2011 07:29:18 GMT

In that case, no, its not a repeating group of fields.

So I should just type the field names in that format in the function dialog or in the code editor for the button used to perform the action?

Re: 2 + 2 + 2 = NaN?

Jimmy — Mon, 07 Feb 2011 06:22:18 GMT

If it's repeating, it would have a little blue icon with a down arrow on it in the data source taskpane.

sum() requires you to specify the specific nodes to sum. It is not intended for summing all the children of a group. If you just want to add together three fields, you're probably best off just adding them together and not using the sum() function:

USCurrency + USCoinage + Checks

Here's your previous thread:

Getting the sum of multiple fields

Re: 2 + 2 + 2 = NaN?

witakr — Mon, 07 Feb 2011 05:44:54 GMT

I'm sorry I didn't mean to ignore you. I can't remember where I posted that question..sorry I don't think it its a repeating group . How do I tell if it is?

Re: 2 + 2 + 2 = NaN?

Jimmy — Mon, 07 Feb 2011 05:29:03 GMT

Is this a repeating, or non-repeating group? It looks like you asked this same question a week ago and ignored my response.

2 + 2 + 2 = NaN?

witakr — Mon, 07 Feb 2011 01:44:22 GMT

Hello folks!

Folks, I am having trouble adding a few fields together. I thought if I put all the fields I need to add together in the same Field Group and used the "sum()" function it would work (i.e. "sum(FieldGroup)") but when I click the button all it says is "NaN"

Would someone please help me figure out what I am doing wrong or if there is a better way to calculate the sum of three fields and display the total in a 4th field?

Thanks so much!

Jay