none
Formula in a report RRS feed

  • Question

  • I have a report that list plants Variety, Container Size, Projected Selling price, projected quantity sold total (formula for Quantity Sold x Selling Price), then it list the Average selling price, Quantity sold, Remaining, % Goal, and Total.

    I need a formula or code to get the average price for the [Container Size]=15. I used =Sum(IIf([Container]=15,CDbl([Total]/[Qty Sold]),CDbl(0))) to get the average selling price but it does not give me a correct number. The problem I think is I have to add all the totals and add all the Quantities Sold to get the correct number. I may have to use variables for these but do not know how to proceed. All help is appreciated.

    Thanks

    Friday, July 26, 2019 5:59 PM

All replies

  • Perhaps

    =Sum(([Container]=15)*[Total])/Sum(([Container]=15)*[Qty Sold])


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Proposed as answer by ForssPeterNova Saturday, August 10, 2019 5:45 AM
    Friday, July 26, 2019 8:29 PM