Skip to main content
S
Sharln5C8F
Participant
October 7, 2021
Answered

Value entered does not match the format of the field - HELP

  • October 7, 2021
  • 1 reply
  • 1787 views

I know there are a million questions about this. I swear I've read them all. They are all nuanced and for a completely illiterate JavaScript person, I'm dumfounded.

 

I have a form with several division calculations. The first is calculating correctly, when information is put into the fields, but before I get to the calculation in question, every other field I type into gives me the error.

I need to divide two numbers (both whole numbers) and the answer needs to be a percentage. So my first field "A" has no formatting, the second field "B" also has no formatting. The quotient field is formatted as a percentage. Here is my JavaScript formula:

 

event.value = (this.getField("TenantSqFt").value / this.getField("ProjectSqFt").value);

 

I read somewhere that calculations don't like formatting. That's great, but when I take away the percentage formatting for the quotient field it gives me a very lengthy decimal. Note that I do not get the error at all when I take the percentage formatting off the quotient field.

 

So either I'm doing something wrong, or I need to adjust the Java Script formula to adjust for this. I can change the formula for it to appear like a percent by multiplying by 100, but I still get the lengthy decimal:

 

event.value = ((this.getField("TenantSqFt").value / this.getField("ProjectSqFt").value) * 100);

 

Ideally my A and B fields would be able to be formatted as numbers (so they can have commas for the thousands place) but if that's a deal breaker I'll have to live with it.

 

So then the next question becomes, do I need to throw rounding into the mix? And how on earth do I do that??

 

Thank you fine folks!!

 

 

 

    Correct answer Nesa Nurani

    Use this:

    var a = Number(this.getField("TenantSqFt").valueAsString);
    var b = Number(this.getField("ProjectSqFt").valueAsString);
    var x = (a/b)*100;
    if(b == 0) event.value = "";
    else
    event.value = x.toFixed(2);

    1 reply

    Nesa Nurani
    Community Expert
    Nesa NuraniCommunity Expert
    Community Expert
    October 7, 2021

    Thats because you try to division with zero, try like this:

    if(Number(this.getField("ProjectSqFt").valueAsString) == 0)

    event.value = "",

    else

    // your code goes here

    You can use "toFixed()" to round to how many decimals you want.

     

    S
    Sharln5C8FAuthor
    Participant
    October 7, 2021

    Thank you for your reply. I'm a complete no-nothing about JavaScript, so I'm not sure exactly what to type. I tried this, but no result.

     

    if(number(this.getField("TenantSqFt/ProjectSqFt").valueAsString) == 0) event.value = ToFixed (((this.getField("TenantSqFt").value / this.getField("ProjectSqFt").value) * 100),2);

     

     

    Nesa Nurani
    Community Expert
    Nesa NuraniCommunity ExpertCorrect answer
    Community Expert
    October 7, 2021

    Use this:

    var a = Number(this.getField("TenantSqFt").valueAsString);
    var b = Number(this.getField("ProjectSqFt").valueAsString);
    var x = (a/b)*100;
    if(b == 0) event.value = "";
    else
    event.value = x.toFixed(2);

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