Applied JAQL formula on top of another JAQL formula result

Hi enmiwong ,

If I understand your question correctly, in the third column you would like to get the maximum value previously obtained on the rows.

Have you tried using multi-pass aggregation?

In your example, it would look like this:

MAX(DIMENSION_IN_FIRST_COLUMN, (10 * MAX([sepal_length]) + 0))

I am attaching an example based on the eCommerce sample data.

Please let me know if this works for you.

Always here to help,
Helena from QBeeQ
[email protected]
QBeeQ - Gold Implementation and Development Partner