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,211 Views

RSS

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

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)

prathyusha melapindi

(@prathyusha-melapindi)

Joined: 8 years ago

Member

Posts: 15

January 3, 2019 5:47 pm

Reply to

Dianne A

Thanks! that worked.

12 Forums
2,533 Topics
11 K Posts
16 Online
2,437 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

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