Hello, the allocation works for the "Cost" but not for the "Budget". Allocation shows 0. (see attached file)

I have checked the master data tables, the formulas... and I don't find the origin of the problem.

Can somebody help me here please?

Thank you :-)

KR

Noémie

Hi Noemie,

I noticed that you have a circular reference in your allocation. It looks like that happened because you have an extra rule in there that isn't necessary.

So I noticed that in the Cost Source master data, when I looked at your Cost Source_Other Cost Pool key, it appears that you modified one of the formulas in the budget file that is appended to the Cost Source Master Data set.

Note that on page 25 of the guide, you add an Is Vendor column to the Acme OpEx budget file. The completed formula has an error because it can't find the Application ID column, but if you read below there is a note that says there is a mistake in the formula, but that's ok. Leave it that way. I see that you modified the formula to something that doesn't create an error, however, that is what's causing your allocation to not work correctly.

If you go back and change the Is Vendor formula to the formula as written, the dollars should flow correctly. I will follow up with my team who built this solution regarding the reason we left that formula as incorrect, but for now, if you revert that formula, the dollars should flow with your allocations, and you should get the correct values.

I did notice also, that you changed the allocation strategy from the default (as described in the notes). It looks like you've deleted one of the default allocations and only have one allocation for cost and budget from CS to OCP. And you used a the Remainder rule in the "From" area and removed the weighting strategy of percent allocated for cost and planned percent allocated for budget. You don't need the remainder rule, as the key formula takes care of running all the other "Is" formulas first. Note in the guide on page 49 step 5 where it says you won't be chaging the allocations configuration screen. It appears that once the formula is corrected, your numbers come out right, but you may see different numbers later in some of the reports without the weighting strategy. So just something to keep in mind.