How do I apply a formula for values in a column

How do I do X?
1

I want the existing values and the new values of a column to be the result of a formula.
Given columns Imposto, Valor_Liquido and Valor_Bruto:

Imposto = 6,15% of the value in Valor_Bruto
Valor_Liquido = value of Valor_Bruto minus the value of Imposto

All these values are currency types computed by the following formula:

{{parseInt(currentRow.Impostos).toLocaleString(‘pt-BR’, {
style: ‘currency’,
currency: ‘BRL’,
})}}

2

You can add a custom field Imposto and in the computed value control, add binding like {{ currentRow. Valor_Bruto * 0.0615 }}

1 Like