I'm trying to get an average at an order ID level. I'm not sure if this is the correct formula to use.
{Fixed [Order Id]: sum([REAL REAL FIXED FEE])/sum([Quantity])}
I have a type of order that = either order or refund. I put a filter on type = order to exclude the refunds (which have the same order ID). However it seems like this filter is not working as any order that has a correspond refund has a lower average (because I think it is counting quantity from that refund). How can I fix this?
Also, this formula doesn't calculate correctly when there are multiple rows with the same ID. I thought that was the point of fixed, no?