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?
Answer
Show positive numbers with plus sign
- Hero
Best answer by Mark Jongeling
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.
This topic has been closed for replies.
+23Hey 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.