Discussion Locked

Interdev DTC Grids and Sum

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I'm using MS Interdev 6. I'm working on a grid with a numerical column, I'm trying to add the column up using a DTC label with the expression =sum([score]) where score is the name of the field. However i'm not having much success. Any suggestions?

5 replies

by rberman

Michael -- well that previous answer didn't help, did it?

I've used DTCs on numerous projects with excellent results. Some folks never have the patience to learn them, so they think they don't work. In fact, they work very well and can save youa lot of time once learned.

However, a DTC is not a spreadsheet. Think about it -- you're going to get a row for each row returned from your database. So summing that would not yield a final result -- it won't add a column.

However, there maybe one way to do this. I'm going to assume you want a running total, so the total will "add up" on each row, with the final row holding the final total.
Just prior to the grid, so something like:

Now use:
=addTotal([score]) INSTEAD of the column where you have just "score".

In the column where you want the running total, use: =lScoreTotal

This will give the running total.

Good luck.

This discussion is closed to new replies.