Forum Discussion

OSAdmin's avatar
OSAdmin
Valued Contributor II
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

Sort By
  • OSAdmin's avatar
    OSAdmin
    Valued Contributor II
    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