i'm doing an item saved search and in one column i am summing inventory location fields, in another i am summing transaction fields. I am using sum distinct but if i have two transactions for 10 they are summing as 10 instead of 20 because the line item and quantity is being duplicated, it doesn't care that they are different transactions. any way to do this in a search?

are you using group?

group {item} sum distinct {transaction.quantity} sum distinct {locationonhand} if multiple locations have the same on hand or multiple transactions have the same quantity they are summed as if they were duplicate lines