Numerical labels of Matrix columns are confusing with the form calculations. Please help.

  • Profile Image
    maryann61744
    Asked on September 01, 2016 at 05:56 PM

    Hello,

     

    I'm trying to use numerical labels for my columns, such as:

    1-2/wk <span> 1 </span>

    3-4/wk <span> 2 </span>

    but these numbers are confusing the form calculation. Is there something I need to do to tell the system that these numbers are text and aren't numbers that are values for the column.

     

    Thank you

    MaryAnn

  • Profile Image
    Kiran
    Answered on September 01, 2016 at 06:10 PM

    You may assign the calculation values to the matrix input fields from the Options tab in the Matrix field properties. Please see the image below:

    When the calculation values are assigned to the field, the numbers in the labels should be ignored. Please give it a try and let us know if you need any further assistance. We will be happy to assist. 

  • Profile Image
    maryann61744
    Answered on September 02, 2016 at 09:24 AM

    Thank you! That worked. I was putting the calculation values like this, which was why it wasn't working:

    1

    2

    3

    4

    5

    There was no place in the help that mentioned the entry format for the calculation values.

  • Profile Image
    Chriistian
    Answered on September 02, 2016 at 10:35 AM

    Hi,

    On behalf of my colleague, you are welcome. Glad to hear the we were able to help. If you need further assistance, please don't hesitate to contact us again.

  • Profile Image
    maryann61744
    Answered on September 02, 2016 at 11:32 AM

    Thank you Chriistian. I have another question.

    In the report, the value from the matrix is showing both the label and the number I assigned for that selection. How can I remove the column label from showing up in the excel report. I only want to see the value.

     

    Thanks again,

    MaryAnn

  • Profile Image
    Kiran
    Answered on September 02, 2016 at 12:21 PM

    @MaryAnn,

    Your other question is moved to a separate thread and shall be answered there shortly.

    https://www.jotform.com/answers/923214

    Thank you!