Showing Decimals as Percentages

(2 posts) (2 voices)
  1. rpark, Member

    Hi,
    I am trying to simply show 99% if a user enters 0.99, and 99.99% if the user enters 0.9999.

    I am using the following colstyle:

    '%.2f %'

    However, it does not parse the percentage out from the decimal, it accepts the decimal as the decimal portion of the percentage. So, if a user enters say 0.99 it will be displayed as 0.99 % which makes sense because of the '.2f' portion, but I would like traditional parsing of the percentage but at this point I can't figure it out...

  2. myDBR Team, Key Master

    Where does the user enter the value, in report parameters or in editable report?

    Column style is an enhanced printf-statement, so style '%.2f %' will format a number with two decimals and adds a %-sign. If you have data 0.99 and want to show it as 99%, select the data*100.

    --
    myDBR Team


Reply

You must log in to post.