Syntax

EvGTS(AppName,ScaleValue,[dim:]member1,[dim:]member2,[dim:]memberN)

AppName — The name of the application. This is required if the corresponding dimension does not exist in the active application.

ScaleValue — If the scale property in the Account-type dimension is Y, then EvGTS uses this value. If the scale property is N, this value is ignored. The scale value can be set to 1, 100, 1000, or 1,000,000. The default value in report templates is one (1). When the scale value is 1 (units), this function works identically like the EvGET function.

Member1–n — You can specify as many members that you want. Any dimension not specified in the formula is taken from the current view. If you supply only the period and not the year, EvGET uses the year from the Category's YEAR property. For example, EvGET(Finance, Jan,Budget,GlobalMotors, Revenue,AllProducts) uses the year specified in the Budget category YEAR property. If that year is 2008, the example gets data for the period Jan.2008.

If the same member name is used in more than one dimension, you must specify the dimension name. Use this syntax: dimension:member.