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

Marco's avatar
Marco
Contributor II
2 months ago

How to round the result of a calculation?

Hi everyone, I would like to round the value for a calculation, I try wit this api.Data.Calculate("A#P_EBPPrct:O#Import:U1#D0000:U2#P0000:U3#CORP_ADJ:U4#PJ00000 = Round(Divide(A#433100, A#41100...
Admin
Finance
System
jayaleck's avatar
jayaleck
New Contributor III
2 months ago

try this -

Private Sub OnEvalDataBuffer(ByVal api As FinanceRulesApi, ByVal evalName As String, ByVal eventArgs As EvalDataBufferEventArgs)

Dim resultCells As New Dictionary(Of DataBufferCellPk, DataBufferCell)

For Each kvp As KeyValuePair(Of DataBufferCellPk, DataBufferCell) In eventArgs.DataBufferResult.DataBufferCells

Dim resultCell As DataBufferCell = kvp.Value

If resultCell IsNot Nothing Then

resultCell.CellAmount = Math.Round(resultCell.CellAmount, 2)

End If

Next

End Sub