Data Buffer error during calculation

[OSAdmin]

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.

[OSAdmin]

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