Forum Discussion

HHoensheid's avatar
HHoensheid
Icon for OneStream Employee rankOneStream Employee
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 

NicolasArgente's avatar
NicolasArgente
Valued Contributor
3 years ago

Good! 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 šŸ˜Š

  • vpidala's avatar
    vpidala
    New Contributor II
    1 year ago

    .