Skip to main content
F
Finn-Ole250517132r3v
Participant
July 4, 2022
Answered

if/else calc.

  • July 4, 2022
  • 2 replies
  • 433 views

Hello.

Just look at my picture.

 

Im thankfull for any help 🙂

 

This topic has been closed for replies.
Correct answer Nesa Nurani

As 'custom calculation script' of "Text37" field use this:

if(this.getField("Check Box36").valueAsString != "Off")
event.value = Number(this.getField("y").value)*.38*100;
else
event.value = 0;

2 replies

Nesa Nurani
Community Expert
Nesa NuraniCommunity ExpertCorrect answer
Community Expert
July 4, 2022

As 'custom calculation script' of "Text37" field use this:

if(this.getField("Check Box36").valueAsString != "Off")
event.value = Number(this.getField("y").value)*.38*100;
else
event.value = 0;

ls_rbls
Community Expert
ls_rblsCommunity Expert
Community Expert
July 4, 2022

You may need to be more specific.

 

What exactly are you trying to calculate when the checkbox is in checked state?

 

And where are you trying to run the desired script from?

 

If this is a conversion from USD to EUR,  what is "0,38"... is this the exchange rate?  And if it is a known exchange rate why is it expressed witha comma?

 

Shouldn't it be 0.38, in which case, I don't understand why the exchange rate is hardcoded into the equation since this value varies daily.

 

But like I said, please explain in more detail what field is the USD which field contains the calculation for the exchange rate, and what formula are using to convert from US dollar to Euros?

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices