Sum multiple fields in one record

Jet Reports Historic Posts

February 10, 2011 18:05

None

Hi,

Is there a quicker way to sum 12 fields in one record?

One record contains the account no, and budget for the 12 months in different fields.

I want to sum the 12 months.

Thanks

Jacques

Date Votes

1 comment

0

Jet Reports Historic Posts February 10, 2011 18:25

Hi Jacques,

How about:
=NL("Sum","Tablename","=NF(,""Fieldname1"")+NF(,""Fieldname2"")+…etc…+NF(,""Fieldname12"")")
Please note that you need to enter 2 double quotes around Fieldname. This is required because you are nesting a function within a function.

Does this do the trick for you?

Comment actions Permalink

Please sign in to leave a comment.