Current Position:Home > EvDRE - SortRange - AfterRange - Copy Excel formula

EvDRE - SortRange - AfterRange - Copy Excel formula

Update:11-30Source: network consolidation
Advertisement
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 the Excel formulas to the line with the EV_AFTER and the copy was like standard Excel.
e.g. - In the AfterRange I would specify cell B2. in B2 I would write the formula A1B1.
When the EvDRE would run, assume that the after range had to be in cell E16, The value of E16 would be the result of the formula D15+E15.
This year we have upgraded to SP06. This functionality stopped working. I tackle 2 situations:
1. If the cell is defined in general format - the system simply copies the result of the formula. In the example above if A1+B1 is 0, I would simply get 0 all over (copy the value and not the formula).
2. If the cell is defined as TEXT in Excel, the original formula is copied (i.e. in the example above all cells would have the formula A1+B1).
evsub works as it should.
Any idea why did this happen? is there a note? does the system now works as it should and I simply enjoyed a bug in SP04?
Thanks,
Avihay

The Best Answer

Advertisement
Hi Ethan,
I have Accounts in Rows and Time in columns. Range E24:E26 is in AfterRange filed on column expansion. 'E24:E26' range adds prior 2 time columns. I want to display this summation on a particular condition, say only if cell D11 = 1. So I wrote a formula in AfterRange field in Column expansion: =IF(D11=1,"E24:E26","") .
This formula in AfterRage field doesn't work. But if I manually type value 'E24:E26' in that field, it correctly adds up prious 2 time periods. I think the issue is with formatting.
Thanks, John
  • 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

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

  • Excell Formulas to Javascript Update:11-30

    I just got a request to convert an Excel file to PDF, and make the form calculate.  The calculations are pretty complex (at least to me they are).  There are four different types of formulas needed.  I've copied the information below.  Can someone he

  • Excel formulas are disappearing in Input Template when i was refreshing Update:11-30

    Hi Guys, Early we are worked on 7.5.07NW(Admin and Excel),in that General excel formulas are worked fine in Input Template as per my requirements but now we changed from SP07 to SP10(Admin and Excel),.Now we are entering any excel formulas in Input T

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

  • Copy Excel Chart into Illustrator: Problem with dotted lines Update:10-11

    Copying an excel chart (2010 and/or 2013, Windows 7 Ultimate) to Illustrator CS6 works okay if line chart lines are solid... but if they are dotted, then in Excel 2010, the dotted line becomes jumbled, and in Excel 2013, the dotted line converts to a

  • How can I copy a formula to 1,000 contiguous cells in a column? Update:10-11

    How can I copy a formula to 1,000 contiguous cells in a column?As long as the cell uses "relative" forumla, I usually take an intelligent brute force effect: Copy 1 to another, copy the 2 to 4, 4 to 8, 8 to 16, 16 to 32, 32 to 64, 64 10 128, 128

  • 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