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

Forum|Forum|3 years ago
March 15, 2023
2 replies
0 views

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 error message on certain intersections:

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

Does anyone know what is causing this our how I can overcome? Even a single intersection error wrecks my cubeview presentation as you can see with the attached image.

I'm able to recreate the math in excel and the result doesn't seem unwieldy, so I'm not sure how to resolve.

Thanks,

SeanUD8 CAGR Business RuleError Message being thrownMath - highlighting intersection with error via a QuickView

Finance

J

JackLacava

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.