Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2015

    Unanswered: Ina report with multiple quantities, picm only one quantity for total

    I have a report that pulls the quotes we do for the week. Most quote have multiple quantities, say 1, then 10, then 100. I need the total to only pull up the $$ of the highest quantity for the total, or the numbers really dont work


    We quote a part for qty 1 at $5, 2 @4.50 and 10 @ $4

    I need it to only include the qty 10 price in the running total

    Any ideas what formula I need? I tried Maximum but it doesn't seem to work

  2. #2
    Join Date
    Feb 2004
    New Zealand
    Provided Answers: 10
    need a bit more info

    what have you done so far
    hope this help

    See clear as mud

    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008

  3. #3
    Join Date
    Nov 2015
    Quote Originally Posted by myle View Post
    need a bit more info

    what have you done so far
    Sorry, I a total amateur on Crystal; I have done some good stuff, but am 1005 self taught, so its hard to even explain!

    I made a formula so it only picks active quotes, from this year. That works fine. I have a running total that gives me the total amount of parts we have quotes, and that works.

    The only part that does not work is the $$$ total; I honestly don't even know at this point what it is adding. When I ran the report in the beginning of the year, with only a few entries, it seems to work right. But now after having 210 months worth, the total just doesn't seem to work
    The formula I was using is :

    Maximum ({Quote_Qty.Quote_Qty}) hoping that if the quote had more than one quantity, it would only include the highest on the report

    I hope that helps at all!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts