Norvin Posted December 6, 2005 Posted December 6, 2005 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 Posted March 3, 2006 Posted March 3, 2006 (edited) (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
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now