Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

If statement in my Simplified field notation?

Community Beginner ,
Mar 21, 2025 Mar 21, 2025

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......

 

 

TOPICS
How to
132
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
1 ACCEPTED SOLUTION
Community Expert ,
Mar 21, 2025 Mar 21, 2025

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;

 

View solution in original post

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Mar 21, 2025 Mar 21, 2025

If statement is there not possible.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Mar 21, 2025 Mar 21, 2025

how can I get the SubPayment field to show a zero or blank if there is no amount in the EIPayment1 field but do the cal I mentioned if there is

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Mar 21, 2025 Mar 21, 2025

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
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Mar 21, 2025 Mar 21, 2025
LATEST

Thank you so much!!!!!!!

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines