This is a transaction saved search. The problem is the last formula field. I need to be able to grab the location on hand from the item record based on the location on the transaction. Because of that last formula, the other numeric values are being duplicated or so as well.

It does' make sense that because of the last formula the other lines are showing the wrong data 🤔 If you run your report only on the last formula, does every line shows the correct value?

Because underneath the search, NetSuite lists down all the locations from the item record. So the other numerical fields are multiplied by the number of locations since the Summary Type is Sum for the others.

This is how I avoid that situation. It's comparing the transaction’s location only when it matched the item’s location data. DECODE({location},{item.inventorylocation},{some field},0) (I'm on my phone so can't see the exact fields you want. )

We do something very similar to what @Netsuite Tragic is saying. Except we put it in the criteria of the search. I set it up like this CASE WHEN {location} = {item.inventory location} THEN 1 ELSE 0 END Is equal to 1 Then you will only get 1 row instead of it being duplicated multiple times

Thank you! It worked. I did something similar to your suggestions. I just used the same formula I have in the Results except to get 1 instead of what I originally wanted. CASE WHEN {location.id} = {item.inventorylocation.id} THEN 1 ELSE 0 END Is equal to 1