COPA Report Error

[former_member228896]

Dear Experts,

We have created COPA ContribAnalysis Report ( 2 Axis with Form) and the column 1got the Actual Values

This column1 has got sales qty, sales rev, sal.deductions, net sales, variable cost, Contribution ,fixed costs, dep etc

Now the client wants have % column added next to column 1.

This column2 should should have a formula Sales Returns % = Sales Returns/ Sale Rev

Sales Deductions % = Sales deductions/Sale Rev

Net Sales %= Net Sales /Sale Rev

Variable Cost % = Variable Cost/Sales Rev

Contribution % = Contribution Cost/Sales Rev

Fixed Cost % = Fixed Cost /Sales Rev

Depreciation% = Depreciation/Sales Rev

Similarly Client would like to add per unit column next to Column 2 , giving the per unit price/ cost of revenue and Expense

Please send your valuable inputs for the above scenario

Advance Thanks

Sanjai

[Former Member]

HI,

You cant define Formula in the column as per my knowledge.

As per your requirement, you can define the percentages below the respective value field for which you require %.

In the drill down report, you can see the percentage column besides the amount column.

Thanks & Regards,

Ravi Kumar