PCMCS Allocation Results do not match exactly with Manual Excel Formula
SummaryPCMCS Allocation Results do not match exactly with Manual Excel Formula
In the process of reconciling PCMCS Allocation results using excel formula, we always find some decimal differences at level 0 members. Sometimes, we even find differences of up to 5 dollars. But, at total level all these differences sum to 0. At summary level, allocation results mostly tie with excel formula.
Need ideas and suggestions on why this could be happening? Has anyone observed this? Does PCMCS engine perform rounding? Is there a way to fix this rounding or precision settings?