Skip to main content
Solved

Using an aggregate total from one GI on another GI

  • December 3, 2024
  • 3 replies
  • 44 views
L
Captain II
Forum|alt.badge.img+5

Hello,

I have created a GI and am using that as a data source for a second GI.

This works.

However, on the first GI I have a SUM aggregate value that I want to be able to use on the second GI.  The field being SUMed is a formula.

This SUM aggregate value is available to me on the results tab of the second GI.  However, if is not available to me to use on the conditions tab.

Thanks!

Larry

Best answer by ejmillar

Hi Larry,

It’s not possible I’m afraid.

You could use a filter on the view to work around that.

Kind regards,

Ewan.

 

View original
If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
    Did this topic help you find an answer to your question?

    3 replies

    ejmillar
    Varsity II
    Forum|alt.badge.img+1
    • ejmillar
    • Varsity II
    • 60 replies
    • Answer
    • December 5, 2024

    Hi Larry,

    It’s not possible I’m afraid.

    You could use a filter on the view to work around that.

    Kind regards,

    Ewan.

     

    Ewan ~ Rubech IT ~ Please remember to "Mark Best Answer" to help those who are facing the same problem.~
    Chris Hackett
    L
    2 people like this
    • Chris Hackett
      Chris Hackett
    • L
      ltussing03
    L
    Captain II
    Forum|alt.badge.img+5
    • ltussing03
    • Author
    • Captain II
    • 290 replies
    • December 5, 2024

    Ewan,

    Thanks for confirming.  I had used a filter on the GI and made the filter the default.  Not ideal, but works.

    Thanks for responding!

    If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
    Chris Hackett
    1 person likes this
    • Chris Hackett
      Chris Hackett
    D
    Varsity I
    Forum|alt.badge.img+3
    • dgodsill97
    • Varsity I
    • 217 replies
    • March 14, 2025

    I have a GI that sums the AR Balances from all the branches grouping by Customer.  the second GI, using the first as data source, conditional selects the records using the aggragation of the first query.

     

    Chris Hackett
    1 person likes this
    • Chris Hackett
      Chris Hackett

    Reply


    Most helpful members this week

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings
    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