Current Position:Home > How to use Excell formula's within EVDRE

How to use Excell formula's within EVDRE

Update:10-11Source: network consolidation
Advertisement
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 empty rows in between, which are filled up with excell formula's. The row key range is adapted, so it does not reference the excell formula's. If we hit refresh workbook, our P&L is ready and displaying the correct data.
Problem now is if we select 'expand all'. My entire P&L structure is changed and displayes the last section of the row key range several times (as many as we have different row key ranges) ... I've put "noexpand" on all of the dimensions on row and column ...
So normally does one use the functionality of excell formula's within a EVDRE report?
D
solved it

The Best Answer

Advertisement
Hi D
One way is to switch of the expansions and insert the rows and then have the subtotals. to swith of expansion just edit the cell where you have written the evdre function and then remove the formulas pointing to expand range.
EVSUB in after range would not work here as the whole range is related to one dimension and it works if we have two dimensions and need subtotals
Regards
Harish B K
  • 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

  • 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 - 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

  • 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

  • How to convert an Excel Formula to a Custom Calculation Script in a Adobe Acrobat 9 Form? Update:10-11

    Hello, I am not familiar whatsoever with Javascript and need some help in converting the following Excel Formula so that I can enter it into a Custom Calculation Script in a Adobe PDF Form. Here is the formula: =IF(E15<25.01,9.95,IF(E15<50.01,11.95,

  • 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

  • Numbers Equivalent of Excel Formula for Converting HH:MM:SS to DD:HH:MM:SS Update:11-30

    I am not sure if this has been asked before. What would be the Numbers formula for converting HH:MM:SS to DD:HH:MM:SS?  The Excel formula is entering 396:59:45 into a cell and then in another cell is the following =TEXT(A2,"dd:hh:mm:ss").  The A

  • Retrieving BEx Query Results Area for use in Excel formulas Update:11-30

    Hello, I run BEx queries in workbooks and then use Excel formulas ( mostly VLOOKUP(LookupValue, ResultsArea, ColumnReturned,) ) to retrieve certain information from the query ResultsArea. ****Problem: Depending on the query parameters, the query "Res

  • How do you display excel formulas? Update:11-30

    How do you display EXCEL formulas in Numbers once imported?select the cell and look at the bottom of the window or doubel click the cell: after double clicking cell:Read other 2 answers

  • Convert mathematical formulat to excel formula Update:11-30

    I have a formula that was generated by excel when using a trendline on a graph. I need to convert this formula into an excel formula I can use again. the formula is below. Assume that the value for X will be in Cell A1. Any help converting this to an