Function: percentage()


percentage(<Number>, <Number>, <Number>) : Number

The percentage function returns the first numeric parameter as a percentage of the second numeric parameter. The third numeric parameter is used to specify the number of decimal places used for rounding the final value.

The third numeric parameter is optional. If unspecified, the default rounding value is 2.


percentage(1, 5) => 20

percentage(1, 3, 4) => 33.3333

You can also use the percentage function within related Apps. For example, in a Projects > Tasks relationship, you can calculate the percentage of completed Tasks in the Project:

percentage(@Count of Related Tasks:Status (Completed), @Count of Related Tasks)

Learn more about how you can get started using the Formula Field.

What would you improve in this article?
Powered by:

Type above and the results will be displayed here.