Data Entry with Decimals

Carlotta Fabris
Carlotta Fabris Active Partner
10 Comments Second Anniversary
in Platform

Hi everyone!

 

Recently I had a problem inserting values in data entry that have decimals. I tried with , (so for example 3,89) and it transforms the number in 389,00. If I do the data entry using . (3.89) it takes the right number so 3,89.

I checked the regional settings thinking that I had to have the . as deciaml separator. I found that my regional settings have the comma as decimal separator.

 

Why does Board takes the . if my regional settings have ,?

What will happen if I have . in my regional settings? 

 

Thanks,

Carlotta.

Answers

  • Alexander Kappes
    Alexander Kappes Employee
    Fourth Anniversary 250 Likes 100 Comments 5 Answers

    Dear Carlotta Fabris,

     

    just a few questions:

     

    1. Did you check the regional settings on your local machine or on the machine hosting the web API Engine?

    2. Which BOARD Version you are using?

    3. Your Dataentry is directly to the cube or through Algorithm and reverse Algorithm? For that case did you test directly inserting into the cube?

     

    Thanks for some more informations.

     

    regards

     

    Alexander Kappes

  • Carlotta Fabris
    Carlotta Fabris Active Partner
    10 Comments Second Anniversary

    Hi Alexander Kappes

     

    I answer to your questions here:

    1) I checked the regional settings on the machine hosting the web API Engine.

    2) Version 10.5.0

    3) The data entry is performed on the cube directly. Can the behaviour change if the date entry is performed directly on the cube or through Algorithms and reverse Algorithms?

     

    Thanks,

    Carlotta.

  • Alexander Kappes
    Alexander Kappes Employee
    Fourth Anniversary 250 Likes 100 Comments 5 Answers
    edited March 2020

    Dear Carlotta Fabris,

     

    for that case it should work without any problems. Using Algorithm had problems in 10.5 releases.

     

    You are running your Web API in System Account? Did you check, that the regional setting is also set for this. (Sorry for the german Screenshot)

    image

    You have to check Welcome, because this is the setting for System Account also.

     

    When you perform some changes to regional settings, please don´t forget to restart the BOARD Engine and Web API Engine to get your changes work.

     

    Hope it helps

     

    regards

     

    Alexander Kappes

  • Carlotta Fabris
    Carlotta Fabris Active Partner
    10 Comments Second Anniversary

    Hi Alexander Kappes,

     

    Thanks for your help.

    What does it meas that the 10.5 release had problems with data entry in algorithms? What sort of problems?

     

    Do you suggest to change the regional settings to take as decimal separatore the . and not ,?

     

    Thanks,

    Carlotta.

  • Alexander Kappes
    Alexander Kappes Employee
    Fourth Anniversary 250 Likes 100 Comments 5 Answers

    Dear Carlotta Fabris,

     

    the initial 10.5.0 release had the problem with data entry on algorithm, that it was always performed in "English" regional settings. The regional settings in the os was ignored.

     

    But this was solved in the meanwhile. I locally tested with 10.5.2..28670 (last one in downloads)

     

    Hope it helps

     

    regards

     

    Alexander Kappes

  • Carlotta Fabris
    Carlotta Fabris Active Partner
    10 Comments Second Anniversary

    Dear Alexander Kappes,

    thank you so much. Do you know after which version this problem was solved?

  • Alexander Kappes
    Alexander Kappes Employee
    Fourth Anniversary 250 Likes 100 Comments 5 Answers

    Dear Carlotta Fabris,

     

    inside the download portal you just have the opportunity to download 10.5.0 or 10.5.2. therefore, which is published inside 10.5.1 download article.

     

    Hope it helps

     

    regards

     

    Alexander Kappes

  • Carlotta Fabris
    Carlotta Fabris Active Partner
    10 Comments Second Anniversary

    Thanks for all your help Alexander Kappes!

  • Carlotta Fabris
    Carlotta Fabris Active Partner
    10 Comments Second Anniversary

    Hi Alexander Kappes,

     

    I checked and unfortunatly I am having a similar problem when I do the data entry in an Algorithm.
    I am using the HTML5 Client and when I insert my data with , or . it always considers it as the thousands separator.

     

    What kind of problems could there be in the 10.5.0 when inserting a value in an algorithm?

     

    Thank you,

    Carlotta.

  • Alexander Kappes
    Alexander Kappes Employee
    Fourth Anniversary 250 Likes 100 Comments 5 Answers

    Dear Carlotta Fabris,

     

    ist your dataentry working fine using the windows client for that dataview / Layout configuration?

     

    Like mentioned above in 10.5.0 we had problems with dataentry on algorithm and regional settings.

     

    Do you have UAT System, where you can check your application in last release?

     

    I think that would be the best solution for you

     

    regards

     

    Alexander Kappes

  • Carlotta Fabris
    Carlotta Fabris Active Partner
    10 Comments Second Anniversary

    If I perform the data entry from the client, it seems to work fine using .

     

    Unfortunatly I don't have a UAT System, where I can check my application in last release.

     

    I will consider this option, thank you so much,

    Carlotta.

Categories