Can we filter/Sorting GI lines by highlighted color

To who might also interested in this question:
I did not find a way to filter out in GI directly, but I do find a nearly workaround

That is using side panel and report designer to filter the data.

1， you can add a side panel that navigate to a report screen
2， you make the report line visible only when
=Sum( [ARTran.Qty] )> [INSiteStatus.QtyOnHand]

which it looks like

But for the workaround, I still have 2 small questions, that I shall raise another questions to seek for help

=IIF([ARTran.Qty]>[INSiteStatus.QtyOnHand],1,0)

@porlov Thank you. It really works. Fantastic.

Previously, I remeber I’ve tried a formual like 
(SUM([ARTran.Qty])-AVG([INSiteStatus.QtyOnHand])

in a new column. and it did not work.
But your formula is really working. Thanks again.

Just ran into this post.  I am going to do something similar in a GI and to continue with the example above I will use something like…

Column Name: Filter by Color

=IIF([ARTran.Qty]>[INSiteStatus.QtyOnHand],Orange,’’)

Then I can continue to build on the conditional to allow filtering by other colors. 

I am also looking to color the column with the same function in the style column

=IIF([ARTran.Qty]>[INSiteStatus.QtyOnHand],Orange40,’’)