Skip to Content
0
Former Member
Jul 26, 2010 at 10:03 AM

Calculated Columns and ColKeyRange

24 Views

Hi Expert,

I´m new in BPC and Iu2019m trying to create a simple EvDRE report and add a new column.

Here is de model.

(Time) 2010.Total | 2010.Total 2010.Total | 2011.Total

(Category) Plan | Forecast Plan | Plan

(Account)

Net Income

Account1

Account2

The requirement is to calculate the variance between 2010.Total Plan and Forecast and 2011.Total and 2010.Total Plan as below.

(Time) 2010.Total | 2010.Total | Variance | 2010.Total | 2011.Total | Variance

(Category) Plan | Forecast Plan | Plan

(Account)

Net Income

Account1

I have created a blank column and entered the formulas in the spreadsheet, and have changed the EVDRE to only point to the PARAMETER for expansion on ROW. Whenever I EXPAND ALL or change values in the CV, the formulas in the blank columns are deleted. How do I go about calculating the variance?

I tried to create it in the afterrange and/or beforerange but isnu2019t work for this purpose.... Any ideas?