Skip to main content
Known Participant
October 18, 2019
Answered

Another if/else query - help needed again please *solved*

  • October 18, 2019
  • 2 replies
  • 1024 views

I'm missing something again as this isn't working either 😞

The first part - if "vat rate.10" says Exempt then "vat value.10" will show 0 - works great, but I can't get the next bit to work. If "vat rate.10" contains a value (any percentage), then "vat value.10" should show "aVATRate.10 x "net value.10"

 

 

if (this.getField("vat rate.10").value == "Exempt") {
event.value = 0;
}
else {"aVATRate.10"*"net value.10";
}

This topic has been closed for replies.
Correct answer try67

Use this code:

 

if (this.getField("vat rate.10").value == "Exempt") {
	event.value = 0;
} else {
	event.value = Number(this.getField("aVATRate.10").valueAsString) * Number(this.getField("net value.10").valueAsString);
}

2 replies

try67
Community Expert
try67Community ExpertCorrect answer
Community Expert
October 20, 2019

Use this code:

 

if (this.getField("vat rate.10").value == "Exempt") {
	event.value = 0;
} else {
	event.value = Number(this.getField("aVATRate.10").valueAsString) * Number(this.getField("net value.10").valueAsString);
}
jlehaneAuthor
Known Participant
October 20, 2019

Perfect!!!! Thank you Try 67, much appreicated 🙂

Bernd Alheit
Community Expert
Community Expert
October 18, 2019

To access field values you must use:

this.getField(" field name ").value

jlehaneAuthor
Known Participant
October 18, 2019

So where would that bit go in my poor attempt in the original question?

Bernd Alheit
Community Expert
Community Expert
October 18, 2019