If statement in my Simplified field notation?

4 replies
407 views
Translate

I finally got this to work and the result of this equation goes into a SubPayment field:

WeeklySalary-EIPayment1*WeeklySalary1

However, when there is no amount in EIPayment1 I want the result to be zero in the SubPayment field.

Is there a way to do this? I am a brand spanking new user......

How to

Nesa NuraniCorrect answer

Community Expert

Use this as custom calculation script of SubPayment field:

var ws = Number(this.getField("WeeklySalary").valueAsString);
var ws1 = Number(this.getField("WeeklySalary1").valueAsString);
var ep = Number(this.getField("EIPayment1").valueAsString);

if(ep == 0)
 event.value = 0;
else
 event.value = ws-ep*ws1;

Nesa Nurani

Correct answer

Community Expert

Use this as custom calculation script of SubPayment field:

var ws = Number(this.getField("WeeklySalary").valueAsString);
var ws1 = Number(this.getField("WeeklySalary1").valueAsString);
var ep = Number(this.getField("EIPayment1").valueAsString);

if(ep == 0)
 event.value = 0;
else
 event.value = ws-ep*ws1;

Translate