How do I get the calculator to ignore unwanted text content?

  • Profile Image
    Asked on March 12, 2014 at 06:41 PM

    How do I get the calculator to ignore unwanted text content?

    This is a new problem we just encountered today; the form was working just fine previously.

    My form has a radio button that says

    "Pre-registration $50". It's taking the hyphen as "negative," and adding -50 to the total field. Also I have drop down menus in the form of 1($12), 2($24), etc. It's taking the value to be $112, $224, etc., screwing up the calculation.

    I guess I can change the format so that the relevant field contains just the values we want calculated, but I wonder if there is an alternative solution to this, since it did work before?

    This is a re-post of a comment on How to Perform Form Calculation Using a Widget

  • Profile Image
    Answered on March 12, 2014 at 07:56 PM


    The calculation feature have undergone a revision lately. It must have affected "text" content and must be recognizing it now as operators or sign.

    i.e. if before it only consider hyphen "-" as text., it could be now treating it as negative sign.

    I suggest you try to modify the numerical values that are being calculated to consider this update on the calculation feature.

    Example, put only "-" if its a negative number.

    I hope I am able to answer your question appropriately. Inform us if you need further assistance.