Skip to Content

what is the percentage formula in COPA two axis form report

Nov 18, 2017 at 07:47 AM


avatar image

Hi Experts,

What is the formula to get Percentages against to column in COPA two axes Form Report?

Ex: In below Report format layout: I want to see Material & other components cost percentage on Sales in 3rd column.

Known formula is =

In Costing formula is = (Material cost / Sales)*100

i.e., = (350/1000)*100=35%, [in excel (B3/B$1)*100] I couldn’t able to get the % values in 3rd column.

Lead Column Actual Per % Sales 1000 Material 350 ? Machinery 80 ? Labor 120 ? Other OH 200 ? 750 Profit 250

So could you please help what is the correct formula and where can I get other similar kind of formulas?

Thanks in advance for your immediate assistance.


Shiva T

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers