Forum Discussion

HHoensheid's avatar
HHoensheid
New Contributor II
4 years ago
Solved

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 Exce...
Cube View
  • NicolasArgente's avatar
    NicolasArgente
    4 years ago

    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 

HHoensheid's avatar
HHoensheid
New Contributor II
4 years ago

Hi 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!