envelope calculate function

nusopiti — Sat, 10 Jun 2023 20:43:10 GMT

Hello

I have data were I calculate a column with the moving average using

Col Moving Average()

for a parameter.

I am wondering if there is a function to calculate the min and max envelope line of the data i am not aware of

or is it necessary to program it in jsl?

Best regards

Re: envelope calculate function

Thierry_S — Tue, 09 Feb 2021 05:40:31 GMT

Hi,

This is the solution that Vince Faller (@vince_faller) posted in June (LINK)

This the formula for moving minimum:

Min( :DATA[Index( Min( Row() - 5 ), Row() )] )

Where :DATA is the data column in your table.

For moving maximum, just create another column with the same formula where "Min" is replaced by "Max"

Best