Simple, Maybe Too Simple!!!!!

[mtownbound]

CR 9
Win 2k Pro
Excel as db


This is my data:

Date Saleperson Shoes sold Sold to males Percent
5/12/03 Smith 80 20 25%
5/13/03 Jones 100 50 50%
5/14/03 Walker 50 5 10%

Totals 230 75 32%

Now what I need to do is create a line chart that shows the percentage of 32%(which is 75/250*100) NOT the AVG that is going to add 25%+50%+10% and show 28.33% on the chart.

I know I can't use @total male sneakers percent, because that is a formula based on the running totals. However, is there a syntax that allows me to say:

@total male sneakers percent = (SUM sold to males)/(SUM shoes sold)* 100

There may be an extremely simple solution and if it is I aplogize, but I must be overlooking something!!


Thanks ahead!!!!!!!!!!!!

 

[cmpgeek]

are all the totals running totals?

what i am thinking is that you cound do subtotals for (shoes sold) and for (shoes sold to men) and then use

(shoes sold to men) % (shoes sold)...

on initial thought i think this would work, but i never promise... good luck to you!

ShannonLea

"I keep hitting 'escape' but I'm still here..."

 

[dgillz]

You are 99.9% of the way there.

Insert, field object, formula field. Rather than taking a database field as you did to come up with the percentages in your column, scrool down until you see the summary fields. The will be clearly marked by hte presence of a sigma, meaning this is a summary field.

Then write the formula that you have already written in your original post.



Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com