Current Position:Home > COPA Report  - How to create a complex formula

COPA Report  - How to create a complex formula

Update:11-30Source: network consolidation
Advertisement
Hi SAP guru,
Please shed some light on this issue.
In COPA drill down report, could any of you know how to create a complex formula? My client requires the report to show the conditional formula such as
IF value field 1 is zero, calculate A
IF value field 1 is not zero, calculate B etc..
Your help will greatly be appreciated.

The Best Answer

Advertisement
Hiya,
Specify the formula for that row, then double-click the value and it provides some options. I believe you can manipulate the calculation based on that.
The best option would be to create the Value outside of the report and use the report simply to display it.
Another option would be to use COPA enhancements (using T-Code SMOD) to calculate values. Since you can include ABAP code, you have the freedom to calculate just about anything you want out here.
Alternatively, you could use Actual Valuation (IMG --> CO --> COPA --> Master Data --> Valuation --> Using Condition Records) and input a formula based on an actual value. If the actual value is something like Sales Revenue, you can "map" it to that field within the Condition Type. Assign the Condition Type to a Value Field and provide a Val Strategy to pick it up during Actual Postings (PV = 1)
Hope this helps.
Cheers.
  • COPA Report  - How to create a complex formula Update:11-30

    Hi SAP guru, Please shed some light on this issue. In COPA drill down report, could any of you know how to create a complex formula? My client requires the report to show the conditional formula such as IF value field 1 is zero, calculate A IF value

  • COPA Reporting Update:11-30

    Hello Gurus, In our environment, we are using BW for generating COPA report. Can any one tell me what will be frequency in which the COPA reports will be created in BW. Whether it is Daily or Monthy? I can understand that it is a generic question but

  • How to change formula which is defined in COPA reporting Update:11-30

    Hi Experts, How to change the formula which is defined in for COPA reports (KE30), like contribution margin (sales revenue-admin cost) Can any please give some inputs Thanks and Regards RamHi, Go to KE35 - Select your report - Double click on the for

  • What is the functionality to create report tree for copa reports Update:11-30

    Dear Fellow members, Good day to you! I would need your advise on how to create report tree for the list of COPA reports created by users in Production. Note that currently power user is using KE30 to create these reports. Due to its sensitivity, I n

  • Report Builder chrashes when creating a new formula column Update:11-30

    Dear all, whenever I try to create a new formula column in the data model, that is placed outside of a query, my report builder crashes completely. The same happens on my colleagues notebook. If anyone has an idea why this could happen, please let me

  • COPA Report Formulas Update:11-30

    Hi Gurus, I am facing problem in COPA report formulas. My COPA report is showing wrong figures wherein the figures are calculated by formula. For e.g Actual figure is 40 and planned figure is 10. The percentage (%) variance figure should be 75. But I

  • How we create Variable for Previous year for COPA reports Update:11-30

    Hi Guruss, I am making a COPA report for Current year comparison with previous year from KE31. For 1st column I have created the Variable for current year (which works perfectly) now in 2nd column i need the actual data pertaining to previous. So can

  • How to Create COPA report by using Product Hierarchy? Update:11-30

    HI, I have to create COPA report using Product Hierarchy. Here i need to Bring Variant configuration characterstics to COPA through Product hierarchy. Kindly give me some points on how to start doint this process. Please provide me the steps to creat

  • Change in Key figures for COPA report Update:11-30

    Hi We have changed some formula using T.code KER1 for a element of Key figure scheme which is used in COPA report. How do we find out which all COPA reports will get impacted by this change. Regards, Ramsthat key figure mapping helps you to map the v

  • COPA reporting using costing keys Update:10-11

    Hi, I am using costing keys to access the different cost estimates in COPA. I have done the necessary configuration - created valuation strategy and assigned a point of valuation and assigned two costying keys - one for current and one for future cos