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

If statement in my Simplified field notation?

New Here ,
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
74
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
New Here ,
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
New Here ,
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