Display totals only - not every row 1

[Deb100]

Hello

Can I start by thanking all of you for your help and support in 2006 and wish you well in 2007.

I am using Crystal XI and am using an excel spreadsheet as my database.

I am creating a high level report to show totals. It is grouped by Client. Each row on the spreadsheet has various 'details' for each client, eg. Sold, Purchase, Dividend.

I have a formula that stores the value ('consideration') for all rows where 'detail' equals "sold".
@Profit from Disposals
if {tbl.details} = "Sold" then {tbl.consideration}

I have another formula that sums the 'consideration' for every row that is "sold" for each client.
@Profit from Disposals Value
sum({@Profit from Disposals},{tbl.client})

These formulas are calculating correctly the sum of 'consideration' and giving me a single value, however, it is displaying on numerous rows on the report, once for each row on the spreadsheet, regardless of whether it is a "Sold" row or not. I do not want to display the detail on the report, just the total value, alongside a text box which describes it as a total for "sold".

I would appreciate any help you can give me.

Regards

Deb100

 

[lbass]

If you place your first formula in the detail section, you can right click on it and insert a summary (sum) at the client group level. You do not have to create a formula for it. The inserted summary will appear in the group footer. If you want, you can drag it into the group header, and then suppress the detail section.

If for some reason you want to use your second formula, it should be placed either in the group header or footer, not the detail section (where it will repeat for each row).

-LB

 

[Deb100]

Hi lbass

This is perfect, and thanks for such a quick response!

Happy New Year.

Deb100