Sunday, January 6, 2019

Average selling price calculation (Total Revenue/Total Quantity Sold)

1.     Navigateto Reports > Sales > Sales > Sales by Item> Customize Detail

2.     HighlightQty. Sold column and set Add Grand Total = True

3.     Click AddFormula field

4.     Setthe following field values:

AddGrand Total = True

FormulaType = Ratio x/y

x= Revenue

y= Qty. Sold

ApplyFormula to Grand Total = True

5.     Renamethen Save the report or hit Preview

No comments:

Post a Comment