Move 2 Decimal Places Over to left

  • Resolved Susp3nc3

    (@susp3nc3)


    2 years, 10 months ago

    I have been trying the PREC and the ROUND function to no avail. I am trying to calculate a percentage and it would be awesome to make the percentage of 0.86344% just to 86%. The percentage changes upon many different inputs.

    Right now I am using this as the equation to get the percent.

    (fieldname69+fieldname78+fieldname13)/fieldname19

    Any help is greatly appreciated.

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello @susp3nc3

    If you have the equation’s result as a decimal and want to transform it into a percentage value, you should multiply it by 100. If you prefer to remove the decimal places, you can combine the mathematical operations with the ROUND operation:

    ROUND((fieldname69+fieldname78+fieldname13)/fieldname19*100)

    Best regards.

    Thread Starter Susp3nc3

    (@susp3nc3)

    Amazing, thanks!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Move 2 Decimal Places Over to left’ is closed to new replies.