Calculated field displaying zero

  • Profile Image
    Asked on March 31, 2015 at 06:39 AM


    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,

  • Profile Image
    Answered 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.

    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.

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