Forum Discussion

Manju's avatar
Manju
New Contributor
6 hours ago
Solved

Dynamic calc

Dynamic calc formula for an account Dim RATE As DataCell = api.Data.GetDataCell("A#RATE:F#99:U7#Top") Dim CALC As DataCell = api.Data.GetDataCell("A#CALC:F#F99:U7#Top")   If api.Pov.Entity.Name...
Admin
Cubeview
XFBR
  • Manju's avatar
    Manju
    6 hours ago

    fixed the formula - changed the account type  updated the formaula pass .working well!
    Dim RATE As DataCell = api.Data.GetDataCell("A#RATE:F#F99:U7#Top")

    If api.Pov.Entity.Name <> "None" And api.Entity.HasChildren() Then
    If P2_TOP_UP_TAX_RATE.CellAmount < 0.15
            Api.Data.Calculate("A#RATE:F#F99:U7#Top = 0.15 * A#CALC:F#F99:U7#Top")
        End If
    End If

     

Manju's avatar
Manju
New Contributor
6 hours ago

fixed the formula - changed the account type  updated the formaula pass .working well!
Dim RATE As DataCell = api.Data.GetDataCell("A#RATE:F#F99:U7#Top")

If api.Pov.Entity.Name <> "None" And api.Entity.HasChildren() Then
If P2_TOP_UP_TAX_RATE.CellAmount < 0.15
        Api.Data.Calculate("A#RATE:F#F99:U7#Top = 0.15 * A#CALC:F#F99:U7#Top")
    End If
End If