AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Acumatica Generic I...
GI to calculate Ave...
 
Notifications
Clear all

Questions GI to calculate Avergae of two columns

 
Acumatica Generic Inquiries & Pivot Tables
Last Post by prathyusha melapindi 7 years ago
3 Posts
2 Users
1 Reactions
3,095 Views
RSS
prathyusha melapindi
Posts: 15
 prathyusha melapindi
Topic starter
December 28, 2018 6:02 pm
(@prathyusha-melapindi)
Member
Joined: 8 years ago

I have a GI which has two columns one with Count(SalesOrders) and another with Count(InventoryID), Count is performed as aggregation on GI for these two columns and now I am trying to achieve a new column which should divide the values from these two columns. Is it possible to achieve in GI? Thanks in advance

 


Topic Tags
Acumatica
2 Replies
Dianne A
Posts: 23
 Dianne A
December 31, 2018 9:36 am
(@dianne-a)
Eminent Member
Joined: 6 years ago

Try this is the new column:  =Count(SalesOrders)/Count(InventoryID)


Reply
prathyusha melapindi
 prathyusha melapindi
(@prathyusha-melapindi)
Joined: 8 years ago

Member
Posts: 15
January 3, 2019 5:47 pm
Reply toDianne ADianne A

Thanks! that worked.


Reply
Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Related Topics
  • Push Notifications
    6 years ago
  • Mass Update Sales Order Status
    7 years ago
  • AR Aged Past Due Inquiry
    7 years ago
Topic Tags:  Acumatica (17) ,
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,532 Topics
  • 11 K Posts
  • 166 Online
  • 2,420 Members
Our newest member: Katerina Pawlowski
Latest Post: Can't export GI's to excel that contain the FATrans DAC after upgrade to 2025 R1 in less than 25 min
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×