Formula to Compute Estimated Gross Profit Percentage based on Gross Sales if adding Est. Gross Profit Percent (Line) column shows incorrect rate.
1. Open and Edit the Customized Sales Report.
2. Click Est. Gross Profit Percent (Line) column.
3. Click Add Formula Field button on the top left of the page.
4. On the Formula Type drop-down menu, choose Percent Ration (x/y)*100.
5. On x drop-down menu, choose Est. Gross Profit(Line).
6. On y drop-down menu, choose Sales.
7. Enable Apply Formula to Grand Total.
8. Hit Preview/Save.
No comments:
Post a Comment