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...
Forum Discussion
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