I create generic inquiry group by inventory id after group I want to filter Qty.On.Hand <= Reorder Point (this is the aggregate field)
Answer
Can we condition after generic inquiry grouping
Best answer by lauraj46
Hi
I have accomplished similar by using aggregate functions in a formula to calculate a new column on the Results Grid. Once you have created this column in the results, then use a saved filter to select only the records that meet the criteria.
This is an example of such a formula:
=iif(sum([INItemSite.MinQty])-sum([INSiteStatus.QtyAvail])>0, ‘Yes’, ‘No’)
You can also use max or min if you don’t want to sum certain fields.
Hope this helps!
Laura
+8Hi
I have accomplished similar by using aggregate functions in a formula to calculate a new column on the Results Grid. Once you have created this column in the results, then use a saved filter to select only the records that meet the criteria.
This is an example of such a formula:
=iif(sum([INItemSite.MinQty])-sum([INSiteStatus.QtyAvail])>0, ‘Yes’, ‘No’)
You can also use max or min if you don’t want to sum certain fields.
Hope this helps!
Laura
Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Hi
I have accomplished similar by using aggregate functions in a formula to calculate a new column on the Results Grid. Once you have created this column in the results, then use a saved filter to select only the records that meet the criteria.
This is an example of such a formula:
=iif(sum([INItemSite.MinQty])-sum([INSiteStatus.QtyAvail])>0, ‘Yes’, ‘No’)
You can also use max or min if you don’t want to sum certain fields.
Hope this helps!
Laura
Thanks
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.