Hello. I am struggling to find a correct formula using the Multi Row Formula Tool. The problem I am trying to solve is as follows:
I have 3 fields (More fields in it but do not concern this new field) : 'Product Number', 'Back Order' & 'Quantity getting received in' and I want a 'Back Order Clearance' field which will be generated by the multi row formula tool. However each Product Number has multiple lines. So I want the 'Back Order Clearance' field to clear the minimum quantity between what is being received in and the back order. And then to carry that to the next line so that is doesn't clear back order that was already dealt with in the previous line (If they are the same Product).
My desired outcome is attached
So far, I have generated a running total of the 'Quantity getting received in' by 'Product Number' as I know this is needed for the tool. However, I can't get the formula to work. Any help would be appreciated, thank you!
