Intermittent issues on our Blogging System

Due to unforeseen circumstances, we are experiencing some intermittent issues with our Blogging system , we apologize for the inconvenience and are working hard to rectify the situation.

Nov 18, 2017 at 07:47 AM
# what is the percentage formula in COPA two axis form report

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 3^{rd} column.

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.

Regards,

Shiva T