Hello， I wrote a GI for our company to hightlight the lines using the below formula：
It works OK. However, you see, we are having 36 pages,
And if the management team would like to view the on hand qty below period usage qty lines,
he have to click 35 times to view all pages.
Is there a way to filter out the lines by the highlight colors?
I am thinking out add a new column with value :
However [ARTran.Qty] should by SUM
while [INSiteStatus.QtyOnHand] is by AVG
This column won’t get the expected result.
Best answer by porlov
Why don’t you make another column near with formula something like:
and let your users filter/sort by it?
And if you still have to use grouping in your GI then I don’t see a problem with using =IIF(SUM([ARTran.Qty])>AVG([INSiteStatus.QtyOnHand]),1,0).
Am I missing something?