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

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