11-18-2017 7:47 AM - edited 02-04-2024 1:44 AM
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 250So 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.
Regards,
Shiva T
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.