Property Calculation Methods

In Formpak, calculation methods are used to help define the logic of calculated properties. There are many calculation methods pre-loaded in Formpak, each providing different methods for calculating properties.

The calculation method of a property can be found on the ‘Calculation’ tab of a property:

You can see more details of a calculation method in ‘View a Property Calculation Method’. This includes information such as the ‘Calculation Source’ and ‘Value Type’ required for the calculation method and ‘Rule Template’ which is the script used the run the calculation for the property. There is also a description to explain the logic of the calculation method.

PLEASE NOTE: We do not advise you make changes to property calculation methods. This could result in incorrection calculation or properties or failed property calculations, preventing other areas of the software functioning properly.

Some of the commonly used property calculations include:

Accumulation
This calculation method will look for the number value of a specific property in the composition of an item. It will then accumulate the sum of this values. An example of a property using this calculation method is ‘ENERGYC’. This property is used to calculate the calorific value of a formulation.

The ENERGYC value of an item will be the total sum of the ENERGYC value for all components in it’s regulatory composition.
There are variations of the ‘Accumulation’ calculation method including a method for accumulating percentage values.

All
This calculation method requires a ‘Yes / No’ value type. It will assign the property to the focus item if all of its components have a specified property. An example of a property using this calculation method is ‘ORGANIC’. This property is used to indicate if an item is organic.

If all components in an item’s physical composition have the ORGANIC property, then the value of ORGANIC for the focus item will equal ‘Yes’.

Any
This property calculation method is similar to the ‘All’ property calculation method, but the value of the property will equal ‘Yes’ if the value of any of the components have a specific property. An example of a property with this calculation method is ‘IFRA49BAN’.

This property is used to indicate if an item contains any components prohibited by IFRA (International Fragrance Association) as per the 49th amendment of the IFRA Standards.

Ingredient Disclosure
This calculation method requires an ‘Entry List’ value type. It will create a list of components from the item’s composition with a specified property. An example of this is property ‘AGNINGDETAILSREG’.

This property lists all components from the regulatory component of the item that have the ‘AGN’ property. This is used to list all the cosmetic allergens contain in an item.

There are also variations for the ‘Ingredient Disclosure’ calculation method including:

• ‘Ingredient Disclosure (by Concentration)’ – This sorts the entry list by concentration.
• ‘Ingredient Disclosure (with zeros)’ – This will enable the list to include all items with the specified property, even when not present in the focus item’s composition. These items will have 0 in the concentration column.
• ‘Ingredient Disclosure by INCI Name’ – By default the entry list will include the components Chemical Name, calculation method will replace the Chemical Name with the INCI Name, if present.

Non Cumulative (Percent only)
This is a variant of a ‘Non Cumulative’ calculation method and requires a percent value type. It will look at all the appropriate limits, and the most limiting factor will become the value for the property. An example of this is ‘IFRACA03’ which is used to show the IFRA Category 3 limit.

This will look at the IFRACA03 limit for each relevant component in its regulatory composition and use most limiting factor as the IFRACA03 value for the focus item. For example, if a component had a limit of 1%, another a limit of 2% and another a limit of 3%. The non-cumulative limit is 1% (the most restrictive of potential limits).

The ‘Non Cumulative’ calculation method works in the same way but requires a ‘Percent and TFV’ value type.