cumProd function
The cumProd function returns the cumulative product of the column, evaluated within groups defined by the group parameter if required.
Parameters
cumProd(column, group)
Parameter | Description |
|---|---|
column | The attribute used to evaluate its cumulative product. Its type must be numeral. The column parameter is mandatory. |
group | It allows you to group the results by a certain attribute’s values. The group parameter can also be a list of attributes. |
Example
The following example uses the Adult dataset.
This example isn’t based on a real scenario, it only explains how to use the function.
Description | Screenshot |
|---|---|
In this example, we want to retrieve the cumulative product of the education-num attribute. Add a new attribute, then type the following formula: |  |
Rulex Platform attributes' memory supports numbers till 5 billion of billions (namely, 5.000.000.000.000.000.000). If the cumProd value exceeds this amount, then negative values or not logical values are returned.