Adding Multiple fields

[NickEveritt]

I am looking to add multiple fields together for a total.

The table they are in looks like this;

Table Name : Volumes
ID
Date
Volume1
Volume2
Volume3
Volume4 up to Volume 96 (all the 15 minute intervals of the day)

How do I quickly sum up all the Volume items of data?

In VBA I know how I would do it, looping through them Volume + X.

How do you do it in Crystal?

Nick

 

[synapsevampire]

Unfortunately I don't think that they have a macro substitution in Crystal to build variables.

If possible, build a Stored Procedure or View to perform this.

The only means I know of is to create a formula that contains something like:

{Volume1}+{Volume2}+{Volume3}...etc.

Then you can create summaries of that formula for any subtotals and grandtotals.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com