The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
HHoensheid
OneStream Employee
OneStream EmployeeError: Value is either too Large or too Small for a decimal
Hello,
I am receiving an error "Value is either too large or too small for a decimal" in a Cube View when I try to divide values in two rows using the cube view math.
When exported into Excel the math for the same division yields 8.2, which does not seem like it would be too large or too small for a decimal.
Example:
GetDataCell(A#NetInc / A#Diluted_Shares_Outstanding_AsAdjusted_DC)
I am trying to divide the two rows shown above.
Using the Excel divide function produces a clean 8.26, which I would not expect to be "too large or too small for a decimal"
The second member is a Dynamic Calc member that dynamically changes the view to either YTD or QTD depending on user's POV, but is not doing any math on the account value itself.
Any help or insight into this issue would be appreciated. Thank you!
Hi there,
Please in your getdatacell can you try with that ; GetDataCell(Divide(S#Scenario1,S#Scenario2)):Name(Ratio)
Say thanks by pressy Kuddos below.
Nic
4 Replies
Hi there,
Please in your getdatacell can you try with that ; GetDataCell(Divide(S#Scenario1,S#Scenario2)):Name(Ratio)
Say thanks by pressy Kuddos below.
NicGood! You are right to use Divide by default as it also reduce the risk of dividing by zero. OS does the magic on the backend 😊
HHoensheidHi Nic,
Thank you, this solution worked. I am still unclear as to why the Divide function works sometimes as opposed to using the "/" operator. the "/" operator has worked before for me, but not in all cases. Seems to be some inconsistency there. I will use the Divide function as a default.
Thanks again!
