Auto Sum for a list of already created sum expressions

K

KittyKitty

I have created a sales table whereby the final column is the sum expression
of the rows of the previous two columns, however when I try to create a total
of this final column I cannot get the expression to auto sum. I have followed
the help options to the letter. Do I need to create different groups or
special fields in the boxes which are already perfoming a sum calculation
before the expression writer will add it together? Am very stuck!
 
J

John

I believe you will need use a textbox rather than an expression box. You can
still use the calculation and fuctions used in the expression box. I suggest
setting the read-only option in the properties of these textboxes so users
cannot modify the field data that has been caculated by your formulas. An
expression box can then be used to sum the final column of calculated values.
If you plan to reuse the grand totoal value, use a textbox instead of the
expression box.

Cheers,
John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top