Calculated field displaying zero

  • sudsport
    Asked on March 31, 2015 at 6:39 AM

    Hi,

    It happens sometimes that my calculated field "Date Naissance" (Birthday) is note set according to data entry and the value is 0.

    When editing the data it is corrected properly.

    Do you have any clue on this ?

    Thanks for your help,
    Georges

    Page URL: http://sud-sport.com/inscriptions_formulaire.php?course=43483095485969&nom_course=ROC%20DES%20MATES%202015&h_forms=1520
  • Kiran Support Team Lead
    Replied on March 31, 2015 at 10:38 AM

    I believe that you are referring to Date Naissance field. Since you are using the calculation field, it is attempting to do the calculation with the numbers selected from the dropdown.

    Calculated field displaying zero Image 1 Screenshot 30

    You may select the fields as text fields to avoid the calculations by selecting Add field to equation as text by default from the advanced options of the calculation widget.

    Also, I see that there is a condition also set with updating the calculation field which is also resulting in calculating the numbers. You'll also need to change the fields to text fields here as well.

    Calculated field displaying zero Image 2 Screenshot 41

    Hope this information helps. Please let us know if you are referring to something different. We will be happy to help.