Relative Change Expression Functions

Summary

  • This section lists the Relative Changed Expression Functions shipped with AdapTableQL
  • These are primarily used when creating Alerts or Flashing Cell Rules

There are 3 Expression Functions available when writing Relative Change Expressions

FunctionExampleWatches for Changes
ANY_CHANGEANY_CHANGE([col1)The Column's value has changed
PERCENT_CHANGEPERCENT_CHANGE([col1) > 5Column has changed by given %
ABSOLUTE_CHANGEABSOLUTE([col1) > 5Column has changed by given amount