Error in business rule

With VB.net, it is possible to calculate with larger number than what the datatype decimal allows you to do, by using floating point data types (single and double). Of cause, to store it back to Onestream, it needs to fit to a decimal datatype. But if only the intermediate results are to big something like this will work:

Dim scriptS As String = "..."
Dim scriptT As String = "..."

Dim number1 As Double = api.data.GetDataCell(scriptS).CellAmount 'i.e. 1000000000000000000
Dim number2 As Double = api.data.GetDataCell(scriptS).CellAmount 'i.e. 1000000000000000000
Dim number3 As Double = api.data.GetDataCell(scriptS).CellAmount 'i.e. 1000000000000000000

Dim result As Double = number1 * number2 / number3
Dim resultDec As Decimal = result

api.Data.SetDataCell(scriptT, resultDec, False)

So, if your calculation only fails, because it has problems with intermediate results (and with statistics this is possible), but the final result are in the range of a decimal, you can calculate it like this.

Be aware, like in Excel, scientific notification looses precision the larger a number gets, so it might not be 100% correct (That's the reason, we are using decimals instead of floats).