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.
+1Hi Larry,
It’s not possible I’m afraid.
You could use a filter on the view to work around that.
Kind regards,
Ewan.
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!
+6I 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
