Monday, July 8, 2019

Formula to Compute Estimated Gross Profit Percentage based on Gross Sales


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