Skip to main content
Answer

How do we show specifically 2 decimals in the Universal GUI when the column its domain is a float, or a numeric with a scale above 2?

  • November 3, 2022
  • 1 reply
  • 100 views

Forum|alt.badge.img+1

We have a domain which looks like follows:

 

In the GUI this is shown as:

 

How can we limit this to 10,93 in this case eventhough our database holds a more specific value. I am aware there are multiple domain controls which can be used. Numeric, percentage and currency have been tested, however this did not do the trick.

Plan B, is to add another column with a scale of 2. But we are trying to avoid this if possible. Does anyone know if this is possible?

Best answer by Tim de Lang

Hi Marijn,

The Universal GUI indeed uses only the scale to decide how many decimals to show. I think your plan B is the way to go here.

Kind regards,

Tim de Lang

This topic has been closed for replies.

1 reply

Tim de Lang
Moderator
Forum|alt.badge.img+4
  • Moderator
  • Answer
  • November 4, 2022

Hi Marijn,

The Universal GUI indeed uses only the scale to decide how many decimals to show. I think your plan B is the way to go here.

Kind regards,

Tim de Lang