CHANGE() Function

The ``CHANGE()` function can be used to specify percentage change over a fixed period (eg 1 week, 3 months) or from a fixed data (eg the 2020 low on March 23rd).

Add CHANGE() to the script editor window and click on the text to change the parameters (the default setting is 1 Day), such as percentage change over the last week:

CHANGE(INT_TYPE=Week)

Change over the last 2 months:

CHANGE(INT_TYPE=Month, INT_COUNT=2)

Percentage change from a specific date

Change the Interval Type to Fixed and select the date from the calendar.

Percentage change between two specific dates

This isn’t possible with the CHANGE function, but here’s a solution on the forum:

https://forum.optuma.com/topic/perfomance-between-two-static-dates