Forum Discussion

CAIGuySeanF's avatar
CAIGuySeanF
Contributor
3 years ago

Unable to execute formula for member "xxx'. Value was either too large or too small for a Decimal.

Hello, I'm attempting to leverage the UD8 Compound Annual Growth Rate (CAGR) business rule as a dynamic calculation.   The formula works great on most intersections, but I keep getting this err...
Finance
JackLacava's avatar
JackLacava
Icon for OneStream Employee rankOneStream Employee
3 years ago

From documents, I believe Decimal values can exist between +79,228,162,514,264,337,593,543,950,335 and -79,228,162,514,264,337,593,543,950,335. If your number falls outside this range, at any point in the calculation, you'll get that error. You can probably break that range even if the number is technically inside the range but having a large amount of decimals.

CAIGuySeanF's avatar
CAIGuySeanF
Contributor
3 years ago

I assumed it could be range driven, but in the example above, I don't ever come close to falling outside this range?