Calculate percentage using summary fields

[Norvin]

I’m trying to calculate percentage of sales by city in a summary report using the get summary function. Below is the formula (I thought would work).

Percentage Value = GetSummary (Total Sales, City) / GetSummary (Total Sales, Total Sales)

Total Sales is the summary field. City is the sort field (break field).

The Total Sales value displays fine in the subsummary part but the percentage value returns 0.00%

Can someone please help me out on this?

[Canucks]

(GetSummary ( Total Sales;City )/Total Sales )*100

This would give you each City Percentage

** Make sure you sorted by city and to give u a better look, goto Preview.

Edited March 3, 2006 by Guest