TripleZ Member

Thanks for the help! Exactly what I needed. MIke

If you mean to use a function called Lag in a Formula tile, I don't see that function as an option. I assume I have misunderstood. Mike

Thanks for the follow up. the REGEXP_LIKE worked for me. Mike

Hmm.. I can't seem to make that work. It still calculates the NetOH using just the qty ordered - qty shipped from that line, then recalculates on the next occurrence of the part number. So results look like this: customer item Qtyordered - qtyshipped Total OH net OH Acme 034662 24 42 18 Acme 034662 12 42 30

Here is the sample data for one part, but the report hold multiple parts. Order Cust Name Item ShipDate QtyOrdered QtyShipped TotalOH NetOH 1234 Acme 1 0335432 2023-10-18 50 0 200 150 3334 ABC Building 0335432 2023-10-18 30 0 200 120 9876 Amazon 0335432 2023-10-18 40 10 200 90 can be sorted by Cust Name or order number and…

I think I was unclear in my explanation. Each of those 4 values are in the same column on different rows. I need a way to look at a column and determine if the first or last character is non-numeric. Thanks, Mike