Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2013
    Posts
    2

    Unanswered: Help with summing

    Hi all,
    I have a report that sums the sales for each product code within a particular category for each month over a 12 month period. We use it to order stock based on our sales. I can total the sales but cannot sum the stock on hand. This is because the stock on hand is represented each line in the detail of the report, say if we have 10 in stock, and there are 10 transactions, the sum result is 100. I have tried a formula in the detail section of the report:

    if {PRODUCTS.ProductCode}= previous({PRODUCTS.ProductCode})
    then 0 else {PRODUCTS.QtyOnHand}

    However this cannot be summed. We can also use running totals which work fine, but we cannot use these within the report. What we want to provide is the percentage of each products stock on hand of the total stock on hand for the category.

    Any help will be greatly appreciated.

  2. #2
    Join Date
    Apr 2013
    Posts
    2
    sorry, forgot to mention, we are using crystal reports version 11

Posting Permissions

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