Current Position:Home > Use of Excel Formulas in EVDRE reports

Use of Excel Formulas in EVDRE reports

Update:11-30Source: network consolidation
Dear Freinds,
I am trying to use excel formulas in EVDER (report).
Account(Base level member)  =SUM(RANGE)
this at somepaces is working and in some places its  not working. Kindly share the knowldge how to use them in excel

The Best Answer

Hi Vishwanath,
Whenever we expandan EVDRE report or Input schedule, the formula (if any) in the first cell is applied to the to the other cells as well. Thus in expansion we will loose any formula specified in the other cells.
If you donot want this to happen, it is better to make the evdre static. This should help you use formulae as required.
Hope this helps.
  • Use of Excel Formulas in EVDRE reports Update:11-30

    Dear Freinds, I am trying to use excel formulas in EVDER (report).                                                   2011.MAR Account(Base level member)  =SUM(RANGE) this at somepaces is working and in some places its  not working. Kindly share the k

  • EVDRE Report and Formatting Update:11-30

    Hi I am quite new to BPC, so my apologies if this is a very basic question, I've created in BPC for Excel ( BPC Version 7, Excel 2003 ) an EVDRE report, which I would now like to format. As my report is static, rather than use the FormatRange, I'd id

  • How to use Excell formula's within EVDRE Update:10-11

    Hi, we want to built a rather large P&L with time in columns and account and cost center in the rows. We would like to insert some subtotals within the P&L strucure using simple excel formula's. So we create the P&L structure and leave some em

  • BPC 7.5 NW: Inserting an excel formula the data col. in an EVDRE input sch. Update:10-11

    Hello, I am trying to design an input schedule for uploading trial balances from SAP. In one sheet, I have an extract of a trial balance from SAP. In another sheet, I have an EVDRE report which has an expansion in rows based upon the entities selecte

  • EVDRE Current View Change displays Excel Formula until Enter is hit Update:11-30

    We have EVDRE reports set up where the user can enter key elements prior to running the report.  Example: Double Click to Select Company =======>   EKCO In the cell where you see EKCO above, we have formula =EVCVW("FinConsol","CompCode&q

  • EVDRE reporting not stable: "hiding columns" & applying datarange formula" Update:11-30

    Hi, we use BPC 5.1. (SP6) With several EVDRE reports we experience that our excell session sometimes stops working, typically when changing the CV and expanding again. At the bottom of the excell we see the statements: "hiding columns" or also &

  • EvDRE - SortRange - AfterRange - Copy Excel formula Update:11-30

    Hi all, In BPC NW 7.5 SP04 I have performed the following actions: I have sorted the EvDRE based on some column and added an AfterRange parameter. In the AfterRange cells I have entered various Excel formulas as well as evsub. The system would copy t

  • Tranport - EPM Inputs/Reports (Excel Formulas) Update:11-30

    Hi Everyone, Can you please some one help me to understand the BPC Transports from Dev to Quality box, the basic doubt I have got is that allowed to move excel formulas along with inputs/reports. (As I heard somewhere it is not possible to transport

  • SAP BPC 10.0 NW - Delete excel formulas Update:10-11

    Hello Experts, I have both "Keep formula on data" chekboxes selected (inside Edit Report and inside Sheet Options) and in my computer when I refresh the workbook the formulas are not deleted, but in other computers, also with the same version of

  • Using "calc' function to show if the cell is editable(EVDRE Reports) Update:11-30

    Hello All, I have a question regarding using the "calc' property in my dimension 'ACCOUNT' in a EvDRE report to display the rows as calculated or input ready cells. I have developed an input template by opening a blank workbook and typing in EVDRE().