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

  • 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