Input in Thousands - Decimal issue

Jordi Vilamajo
Jordi Vilamajo Customer
10 Comments Level 200: Building A Planning Solution in Board Name Dropper First Anniversary
in Platform

Hi,

We have a Dataview to input plan in Thousands. The column on the right is the input one. And the left one, which usually is hidden, is a the real amount.

The right one is the left /1000. And has an invers algorithm, the left is the right x 1000.

The issue which we don't understand is the following: we add 10 units on the right

image.png

And we would expect that this would take into account the decimals. So that would give an amount of 40,710,891 on the left column. But decimals are omitted.

image.png

Is this how BOARD is designed or are we failing to set the correct configuration?

Thanks in advance.

BR

Answers

  • Federica Antonelli
    Federica Antonelli Employee
    Fourth Anniversary 25 Likes 10 Comments Level 300: Expanding Board in Your Organization
    edited May 10

    Hello @Jordi Vilamajo

    This is the expected behavior if, to add 10 units, you are typing 40711 which is the number then multiplied by 1000. 40711000.

    If you use the "Add" option in the lock&spread feature - the existent number is considered and so the decimal is taken into account.

    image.png

  • Jordi Vilamajo
    Jordi Vilamajo Customer
    10 Comments Level 200: Building A Planning Solution in Board Name Dropper First Anniversary

    Thanks Federica. It is clear.

    But from the user point of view, this behavior is not what anyone would expect. In fact for all the rest of operation BOARD is using the whole number that is behind the Thousand:

    image.png

    And it is also confusing that it behaves in one way in the normal screen and in a different one in the Lock and Spread.

    I would include this in the suggestions for new enhancements for future releases.

    Thanks for your time this week :)

  • Federica Antonelli
    Federica Antonelli Employee
    Fourth Anniversary 25 Likes 10 Comments Level 300: Expanding Board in Your Organization

    yes, but in the end it's not behaving differently - on the normal screen, you're typing a new number which is 40771 without any decimals. While in the lock&spread you're leveraging the Add function.

    The ideal would be to type +10 in the cell on the normal screen to increase the existent number by 10 - without using the Add function in the L&S view. This feature was supported in past versions - need to check if it's still the case.

  • Jordi Vilamajo
    Jordi Vilamajo Customer
    10 Comments Level 200: Building A Planning Solution in Board Name Dropper First Anniversary

    Well, that's what we did. We typed +10 in the cell of the normal screen. But did not work. We are still using 12.4 version.

Categories