Input in Thousands - Decimal issue

Jordi Vilamajo · 2024-05-10T08:55:52+00:00

There was an error rendering this rich post.

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

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.

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

Thanks in advance.

Find more posts tagged with

Accepted answers

All comments

Federica Antonelli

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.

Jordi Vilamajo

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:

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

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

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.