You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

EPCM Allocation rule allocates many zero values

Received Response
31
Views
6
Comments

Summary:

We need to allocate each business expenses using sales as a driver.

We have some new business, with no sales. In those cases, we need to allocate its expenses evenly.

We built 2 allocation rules

1) First rule allocates expenses using sales as a driver. It allocates expenses from business with sales (balance=0 in these business), and leaves expenses from business without sales (balance <> 0 in these business)

2) We built a second rule, which allocates expenses evenly. It works for business without sales, but it also allocates 0 to business with sales. 

It takes time and updates many cells unnecesary, writing 0 as a result.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!