Factor in not working in allocation

[Former Member]

Hello,

We are using BPC 7.0MS and we are trying to create an allocation to do a top-down distribution. We take the whole budget for the year and we will distribute it in a linear way through all the months. The allocation is as follows:

*RUNALLOCATION

*FACTOR=1/COUNT

*DIM Time WHAT=2009.INPUT; WHERE=BAS(2009.TOTAL)

*DIM Category WHAT=BUDGET; WHERE=<<<

*ENDALLOCATION

When we introduce data for 2009.INPUT, the same amount is written in all the months, it is not divided.

E.g, when we introduce:

2009.INPUT --> 12000

We get:

2009.JAN --> 12000

2009.FEB --> 12000

2009.MAR --> 12000

...

2009.DEC --> 12000

instead of:

2009.JAN --> 1000

2009.FEB --> 1000

2009.MAR --> 1000

...

2009.DEC --> 1000

Any idea about how to solve this issue?

Thanks and regards,

Ana

[Former Member]

Hey Ana,

Try *DIM Time WHAT=DEP(2009.INPUT);

Let us know if it works....

I'm sure you have gone thru the example..but in case you haven't here it is.

***************************************************

Allocated LeaseCost = LeaseCost * SquareFootage / Total Square_Footage

• RUN_ALLOCATION

*FACTOR USING/TOTAL

*DIM ACCOUNT WHAT= LeaseCost; WHERE=<<<; USING=

SquareFootage; TOTAL= <<<

*DIM ENTITY WHAT= GLOBALOPS; WHERE=>>>; USING=

>>>; TOTAL= BAS(ALL_ENTITIES)

*ENDALLOCATION

***********************************************************

Thanks

Vishal.