Text Field Data Exxx converted to Scientific Notation

Home Forum Reporting Text Field Data Exxx converted to Scientific Notation

This topic contains 1 reply, has 0 voices, and was last updated by  evelina.liu 6 years, 6 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #1013

    evelina.liu
    Participant

    I am not sure if anyone had this issue before. I have a form field, Room Number, which expects data such as A001, 5E003, or RM-1234, …. So there is no special designated data format tied to this field. It seems that all the form instances are ok from this field. However, when viewing this column on the report, all the data with “E” will be automatically translated to something else, because E is treated as an scientific notation, therefore Room Number “12E03” will be automatically converted to “1200” on the report, etc. Is there a way to correct this and also to all the form instance I have so far?

    Thanks.

    #6098

    Thank you for bringing this to our attention. I will submit a request to the Development team!

    Workflow software, Process software, Procedure software

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.