Like this examble:
Order 1 has 4 order lines
Order 2 has 3 order lines
Order 3 has 5 order lines
Average pr. order 4 order lines.
I will use order line with order line items.
Need to use these :
Order:owner name
Description
Quantity
Hope somebody have made this before - could not find it.
8 件の回答
Okay for that I would use Tom Tobin's "power of One" technique
Tips & Tricks: "The Power of One" the Greatest Formula Ever Written*
https://trailblazers.salesforce.com/answers?id=9063000000048RbAAIThen you can create a Report Summary Formula like this
OrderItem.Order_Product__c:SUM
/
Order.Order__c:SUM
