I cannot figure out what I am doing incorrectly. I can apply the Units Metric to a Category value and get the correct result but when I try to build a calculated metric using Units and a segment for a category the results don't match.
Example I have 2 categories for products; Flights and Ancillaries. When I use the units metric against those I get the correct results Flights 1768 and Ancillaries 581. However when I try to create a calculated metric for just Flights Units (Category=Flights segment) I get the total; 2349. I think it has something to do with the fact those categories are always purchased together even though I am sending in separate products variables with the purchase event.
Seems like this should be a simple metric to create but I cant seem to find the magic formula