Welcome! Log In Create A New Profile

Advanced

Total Columns

Posted by Joel 
Forum List Message List New Topic
Joel
Total Columns
March 27, 2009 03:30PM
Hi -

I have a table that contains line items for an invoice. I'd like to total the "COL_Amount" cells for each row and then put the total in a field elsewhere on the form. How do I do that?

thanks -
Reply Quote
Arie
Re: Total Columns
March 27, 2009 04:51PM
Joel,
You can get this result in your code, referencing the totalrow, by the use of the rowtotal constant. You have to set your COL_Amount to calculate the sum. This can be done on the details-tab of that column.

i.e.: cyResult = InvoiceTable.Amount[rowtotal]

Arie

Reply Quote
Newer Topic Older Topic
Author:

Your Email:


Subject:
Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.
Message: