Number Format - leading plus

(3 posts) (2 voices)

Tags:

  1. Adrian, Member

    Is there any opportunity to format a number with a leading plus? (apply a number style?)
    like in excel => +#.##0;-#.##0

    i.e.
    +212
    -500
    -123
    +1.132

    or percent
    +1,7 %
    -0,4 %
    ...

    Of course I could concat a '+' in the SQL statement if the value is greater than 0, but I would lose the default format (thousand sep., right alignment, etc.)

    Any suggestions?

  2. myDBR Team, Key Master

    Adrian,
    you can add the sign to the format:

    select 'dbr.colstyle', 'column', '%+d;%d;%-d';

    --
    myDBR Team

  3. Adrian, Member

    Thanks!


Reply

You must log in to post.