Solved

Show positive numbers with plus sign

  • 19 November 2019
  • 1 reply
  • 38 views

Userlevel 4
Badge +10

For certain contexts where we show a difference between values it makes sense to display positive numbers with a plus sign. For example a difference of 5 displayed as “+5” in a list or a cube. I looked for a domain control to see if the gui offers such an option but I couldn’t find it. Is there a straightforward method or do I have to convert numbers to varchar to accomplish this?

icon

Best answer by Mark Jongeling 20 November 2019, 08:47

Hey Roland,

As far as my knowledge goes, adding a + in front of a number can only be done by converting it to a varchar or making an expression field with a query that adds a + to a positive number supplied by another column.

Your suggestion would be a great idea to put on here! I think more people would like to use this in their applications.

View original

1 reply

Userlevel 6
Badge +13

Hey Roland,

As far as my knowledge goes, adding a + in front of a number can only be done by converting it to a varchar or making an expression field with a query that adds a + to a positive number supplied by another column.

Your suggestion would be a great idea to put on here! I think more people would like to use this in their applications.

Reply