### Title

How to calculate product (multiply a set of numbers)?

### Post

I need to out put the PRODUCT of a set of number, but it seems this is not a standard function/calculation in FM. Any one can help me to achieve the calculation?

thanks in advance

How to calculate product (multiply a set of numbers)?

I need to out put the PRODUCT of a set of number, but it seems this is not a standard function/calculation in FM. Any one can help me to achieve the calculation?

thanks in advance

Average (mean) can be calculated either with a summary field or the Average() aggregate function.

Depending on your data model, either List or ExecuteSQL could be used with the Evaluate function to compute the product of your data.

If you have this relationship:

Parent----<Data

where you want the product of a value in a field in Data for all records related to a given record in Parent,

This calculation:

Evaluate ( Substitute ( List ( Date::FactorField ) ; ¶ ; " * " ) )

will compute the product

In other situations where a simple relationship won't work, an SQL query inside ExecuteSQL() might be used:

Evaluate ( ExecuteSQL ( "SQL query goes here" ; "" ; " * " ) )

Average (mean) can be calculated either with a summary field or the Average() aggregate function.

Depending on your data model, either List or ExecuteSQL could be used with the Evaluate function to compute the product of your data.

If you have this relationship:

Parent----<Data

where you want the product of a value in a field in Data for all records related to a given record in Parent,

This calculation:

Evaluate ( Substitute ( List ( Date::FactorField ) ; ¶ ; " * " ) )

will compute the product

In other situations where a simple relationship won't work, an SQL query inside ExecuteSQL() might be used:

Evaluate ( ExecuteSQL ( "SQL query goes here" ; "" ; " * " ) )