Incorrect Sum Total
I'm running into what appears to be a rounding error, however I'm not using any rounding formulas. We have a total of 625 employees being allocated across different locations. In the Total Allocation column from this module, my sum is 625:
When running these allocations through a sum by location ('STG: Employee Allocations'.Active Allocation %[SUM: 'STG: Employee Allocations'.Property] / 100), my total becomes 624.9025:
3 employees seem to have a floating point error in their allocation totals. 1 example is pictured below, with the allocations adding to 100 exactly outside of Anaplan:
Allocation amounts with sum in Excel:
These 3 errors accumulate to 0.00000000000009, not the .0975 difference seen in Anaplan. Is there a way to correct this and am I even right in the source of this discrepancy?