Skip to main content
Question

Counted document total in Pivot table is 1 off

  • February 9, 2026
  • 0 replies
  • 6 views
M
Jr Varsity III
Forum|alt.badge.img

Hi, we have a GI that shows Won opportunities per period. Beside the $ value, there is a value that counts how many documents consists of it. However, it adds 1 count to in pivot tables. I’ve used all aggregate functions in Pivot table and Count Distinct is the best option which is still not correct as the value is still one off. If this is not a limitation, how do I correct this?

There is no won in opportunities $50-100k (AUD), but it is showing 1 in the count column beside it
Used Count Distinct as the best option to show the ‘closest’ correct option

 

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