My formula is not adding

luiz_adriano · May 24, 2022, 2:31pm

I don’t know why the values don’t add up, just do subtraction I’ve tried everything and it doesn’t work is it a bug?
IF(appVars.valordoboleto.data.value == undefined, “–”, appVars.valordoboleto.data.value - appVars.desconto + appVars.jurosmulta)

Mihaly_Toth · May 24, 2022, 2:42pm

Is everything of Number type?

luiz_adriano · May 24, 2022, 2:43pm

yes they are numeric

luiz_adriano · May 24, 2022, 2:44pm

only subtraction is working, sum not working

Mihaly_Toth · May 24, 2022, 2:47pm

Then try using the built in math formulas:

ADD(firstnumber, secondnumber)

or wrap the subtraction into a bracket and also the full calculation into a bracket:

IF(appVars.valordoboleto.data.value == undefined, “–”, ((appVars.valordoboleto.data.value - appVars.desconto) + appVars.jurosmulta))

luiz_adriano · May 24, 2022, 2:49pm

you alerted me and I had this idea that worked perfectly thanks!
IF(appVars.valordoboleto.data.value == undefined, “–”, NUMBER(appVars.valordoboleto.data.value) - NUMBER(appVars.desconto) + NUMBER(appVars.jurosmulta))