Operation into javascript

Forum|Forum|7 months ago
September 4, 2025
3 replies
127 views

I am trying to convert this operation into a javascript that does not give me an error message thank you.

((NewValue - OriginalValue) / OriginalValue)

JavaScript

Nesa Nurani

Community Expert

Before calculating check that 'OriginalValue' is not zero, because you can't divide by zero, something like this as custom calculation script (not SFN) :

var orgVal = Number(this.getField("OriginalValue").valueAsString);
var newVal = Number(this.getField("NewValue").valueAsString);

if(orgVal == 0)
 event.value = "";
else
 event.value = (newVal-orgVal)/orgVal;