summary of a caculated field

[wswain]

In a report can you do a summary of a calculated firled.


e.g. calc field = qty * price.


Then I want to summary the total of the calculation. Seems simple (and is in excel), but all I get is Zero in the summary field at the end of the group band.


Bill Swain

 

[footpad]

Bill,

Try

sum( qty * price )

or

sum( qty ) * sum( price )

, as appropriate.

Hope this helps...

-- Lance

 

[wswain]

This looks great as a standard calculation! Where can you actually insert a formula to display as a formated value, say in the lower group band. I am aware of insert field, special, summry, but was not aware of putting a specific formula in was allowed. It was looking for a field to sum.


Bill

 

[footpad]

Bill,

You need to:

1. Place a blank field object in the appropriate footer band,

2. Right-click it and then choose Define Field from the shortcut menu.

3. Check the checkbox next to the Calculated label.

4. Type in the calculation you need.

There are a number of functions available. See Help or experiment with the calculations that Paradox itself assigns with you select a summary operation for a given field.

Note that the return value is reset when the group value changes, so use group bands to control the resets.

Hope this helps...

-- Lance