{{sidenavigation.sidenavigationExpandLabel}}
{{getMsg('Help_YouAreHere')}}: {{page.title}} {{page.title}}
{{$root.getMsg("downLoadHelpAsPdf")}} {{helpModel.downloadHelpPdfDataStatus}}

PercentOfSum

Returns the percentage of this record in the sum of all records for this field matching the condition y.

Usage:

PercentOfSum( fld, condFld )
PercentOfSum( fld, condFld, cond )

Parameters:

fld The name of a field or array variable whose values should be used to calculate the percentage value.
condFld The name of the field that groups the values of fld (if fld isn't an array).
cond A string declaring the type of grouping to be used on condFld. This only makes sense for groups based on Date, DateTime, Time, and Boolean fields. See Summary Field Conditions for a list of strings you can use here.

Returns:

A number.

Examples:

PercentOfSum ({Product.Unit_Price}, {Product.Category})
// returns the total unit price of the products of a given product category.

Notes:

  • If the values in fld should be grouped, a group based on condFld is needed. If the group does not exist in the report, you can add it using i-net Designer or using API method: Engine.addGroup.

See also:

i-net Clear Reports
This application uses cookies to allow login. By continuing to use this application, you agree to the use of cookies.


Help - PercentOfSum