I have a summary search that looks at total inventory on hand, available, committed, etc. across multiple locations. I want to build a flag to identify an item that is backordered at our primary location, but is on hand elsewhere. I have tried a decode and case when function to look at the criteria of location, but end up with two lines for the item on the report instead of one.
Is there a better way to write a formula that can be used in a summary report for if backorder qty at location A is greater than 0 and on hand quantity at location B is greater than 0 then true else false.
When I use that structure, I end up with a line for location A and a line for location B when I group by this field.