Error: 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