Actual change from a value (ACHV#)

This calculates the actual change in value between the current day (for each day within the display time period) and one of:

• The value at a given date
• The value calculated by another function - see Using functions as arguments in other functions
• A date parameter, see Date Parameters.

Format

ACHV#(Expression,Parameter)

Where parameter is the date of the value, or a result from another function.

Examples

ACHV#(MKS,1/1/98)

This calculates the actual change in value between the current day (for each day within the display time period) and the value at 1/1/98 for Marks and Spencers. When used in the Graphics programs, the first value is the actual change between the start date and 1/1/98, and the last value is the actual change between the end date and 1/1/98.

ACHV#(MKS,AVG)

This calculates the actual change in value between the current day (for each day within the display time period) and the average value for Marks and Spencers.

Note: This function can only calculate actual change for individual series. It cannot calculate actual change for composite expressions.

See also

Growth rates & changes in value