AnsweredAssumed Answered

How can I round an input number in the dataview

Question asked by jcbos on Jul 12, 2019
Latest reply on Jul 16, 2019 by jcbos

I have a dataview in which I want sales persons to add the number of quantities that they will sell per month. For this I only want them to be able to enter whole numbers and not decimals. With the validation rule I am already able to set that the number should be zero or higher (so negative numbers are not allowed), however it it still possible to enter decimal numbers into the dataview and therefore also in the cube.

 

As it should be possible to enter numbers above 32.000 I cannot limit the cube to an integer value, so I had to set it to double.

 

I can hide the decimals in the dataview, however this then also makes it invisible if decimals are used.

 

I prefer to have a rounding solution somewhere, but I am not sure how to solve this.

 

Who can help me?

Outcomes