GETEOM returns the End Of Month value of a specified expression or variable. GETEOM is an Advanced Math Toolbox Function.

SYNTAX:

GETEOM(Exp, optional MonthOffset)
where :
Exp is any valid WIMS Expression 
MonthOffset can be any expression that evaluates to a number. The default is zero, meaning the current month.  A positive value means to go back X number of months and a negative value means go forward (into the future) X number of months.

NOTES:

The Advanced Math Toolbox Functions give full flexibility to WIMS users to create new calculations that are not currently available with the existing, predefined functions.  Since these functions are very general and very powerful, they do not have a lot of safety checks built into them and must be used with caution.  The advanced functions will generally be slightly less efficient than the predefined functions and are not therefore intended to replace the predefined functions.

EXAMPLES:

Example 1: Return the monthly average of a variable 3 months ago.

GETEOM(MAVG(C3), 3)

MAVG(C3) : Standard math toolbox function to calculate the monthly average
3 : The number of months to shift back when evaluating the expression, in this case 3 months