Sell through %

Posted on 2009-12-15
Last Modified: 2012-05-08
If i have calculated the correct sell through %
How to i total the sell through % for the group total and Grand total?

If im doing a Crystal report and have my sellthrough {@SELLTHROUGH} feild, I have tried doing a summary on this feild using "AVERAGE" but it seems this doesn't include any products that have a 0.00%


20.00 %
40.00 %
00.00 %
50.00 %

the summary using the AVERAGE function gives me

27.50 % instead of
22.00 %

Am i going the wrong way about this ?
How do i get the right summary for Group and Grand totals?
Question by:kingjely
    LVL 42

    Accepted Solution

    how did u apply Average in your code?
    can u post the relevant code here?
    LVL 14

    Assisted Solution

    is seems to me that 110/4 = 27.5

    is that not the average?

    Where do you get 22 which would have 5 values?
    LVL 8

    Author Closing Comment

    Wrong button, its all good, i got it now, thanks for the replys

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Suggested Solutions

    It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
    Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
    Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
    This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now