if/else calc.

[Finn-Ole250517132r3v]

Hello.

Just look at my picture.

Im thankfull for any help 🙂

[ls_rbls]

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?

[Nesa Nurani · Accepted solution]

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;