Hello,
I'm needing to create a calculation to determine the pay wage percentage increase on a form. I'm struggling with the formula/calculation needed. I am getting an error stating that the field doesn't match the output.
Essentially needing, =((HourlyEmployeesNewPayRate-CurrentPayRate)/CurrentPayRate)*1
As mentioned above you need custom calculation script, something like this:
var a = Number(this.getField("HourlyEmployeesNewPayRate").valueAsString);
var b = Number(this.getField("CurrentPayRate").valueAsString);
if(b)
event.value = ((a-b)/b)*1;
else
event.value = "";
What is the point of multiply by 1?
If you set field format as percentage, then instead of multiply by one, you need to divide by 100.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
AdChoices