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?
Best answer by Mark Jongeling
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.