Skip to main content
Question

Help with Count and Average Formulas

  • July 25, 2025
  • 0 replies
  • 20 views
T
Jr Varsity III

I modified our Historical Inventory report to get average consumption data for a group of periods.

I’m having trouble with getting the correct averages. Here are the formulas I’m concerned with:

  1. =Sum(IsNull([ItemHistCurr.FinBegQty], [ItemHistLast.FinYtdQty]))
    • Not getting the correct ending quantity. (See “4148.000”)
  2. =Sum(([ItemHistCurr.FinPtdQtyIssued] + [ItemHistCurr.FinPtdQtySales] + [ItemHistCurr.FinPtdQtyAssemblyOut] + [ItemHistCurr.FinPtdQtyTransferOut]) / Count([INItemSiteHistByPeriod.FinPeriodID] ))
    • Not getting the correct average (See “1,019.7143”)
  3. =Count([INItemSiteHistByPeriod.FinPeriodID] )
    • Not correctly counting the periods (See “20.00”)

 

In the header: number of periods, Average Consumption, and Ending Quantity is incorrect.

 

 

TamiLynn

    Terms & ConditionsCookie settingsAccessibility statement
    About Acumatica ERP system
    Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
    © 2008 — 2024  Acumatica, Inc. All rights reserved