Hi all, I'm having a rather odd issue with my saved search here.
As you can see, the summed totals for Est Ext Cost and Est Gross Profit are really low compared to the Net Revenue.
When I drill down to view the individual lines, it appears to just be skipping lines altogether. The data IS in these column lines on the transactions and it's picking up 0-3 lines per transaction so there really doesn't seem to be any correlation between the transactions as to why this is happening, it's not always just the last item for example.
Here is the formula I'm using. As you might notice, it is correctly picking up on all of the items when they are shipping and setting them to 0.
I really don't understand why this is happening on the Web Orders, the results come through fine on all of the other Sales Segments.
It's not like is has something to do with the context of the record, because this is just a saved search, the details ARE there in these transactions and just aren't being returned for some reason.
The Web transactions do use different form types, but I have tried changing this and it doesn't appear to affect the results.
Criteria:
Results: