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

OSAdmin's avatar
OSAdmin
Icon for OneStream Employee rankOneStream Employee
6 years ago

Data Buffer error during calculation

Originally posted by Krishna Srinivasan

Hi - I have a custom calc and I am trying to execute the below calculation and I am getting an error has anyone encountered it ? Is this something because the data type  should be in Decimal ?

 

Any help would be appreciated.

 

api.data.calculate("T#2020M2=T#2020M2" * (1 +100) )

Error in DataBuffer.operator *. Error in DataBufferCell.operator *. Value was either too large or too small for a Decimal.

 

dashboards

1 Reply

  • OSAdmin's avatar
    OSAdmin
    Icon for OneStream Employee rankOneStream Employee
    6 years ago
    Originally posted by Krishna Srinivasan

    All - Sorry again I am answering my own question. I found the fix we should use the below format in order to do the calculation.

     

    api.data.calculate("T#2020M2:A#[" & ActMember.Name & "] = 1+ T#2020M2:A#[" & ActMember.Name & "]" )

     

    Hope this will help anyone in future.

     

    Krishna