Filtered total of portal - sum?
I've set up a portal from a related table in my layout.
The Portal shows a list of records with a "status" field and this status can be "Incoming" or "Arrived", and of course another field with the quantity (QTY) number of items incoming or arrived.
I want to add a field to show the sum (or total) of QTY with INCOMING on the "status" field.
I figured that I may need a calculation field but I don't find the way to "filter" the records to sum to have only how many pieces are "incoming.